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