How to convert text to date in Infopath2013 - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

How to convert text to date in Infopath2013

Last post 03-05-2019 08:18 AM by Bmarsal. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 03-05-2019 08:18 AM

    How to convert text to date in Infopath2013

     Hi All,

    In Infopath 2013 I have to calculate a date from a date picker (Primarytermexpirationdate) and a text box (Nextreview). The result goes to another text box (testdatesplit) and contains the day and month from the date picker, and the year from the text field. I did this with the formula  concat(Nextreview, "-", (number(substring(Primarytermexpirationdate, 6, 2))), "-", number(substring(Primarytermexpirationdate, 9, 2))). It works alright, but I need to turn it into a date again, because I have to use it in a SP list as such.

     I tried to google the question and tried several formulas found there, but none of them worked for me.

     Can anyone please advise how to do this?

     Thank you a lot!

     Barbara 

Page 1 of 1 (1 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.