https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/120523.aspxTue, 05 Mar 2019 16:18:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120523Bmarsal0https://www.infopathdev.com:443/forums/thread/120523.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=120523<p>&nbsp;Hi All,</p><p>In Infopath 2013 I have&nbsp;to calculate a date from a date picker (Primarytermexpirationdate)&nbsp;and&nbsp;a text box (Nextreview).&nbsp;The result goes to another text&nbsp;box (testdatesplit)&nbsp;and contains the day and month from the date picker, and the year from the text field. I did this&nbsp;with the formula &nbsp;concat(Nextreview, &quot;-&quot;, (number(substring(Primarytermexpirationdate, 6, 2))), &quot;-&quot;, number(substring(Primarytermexpirationdate, 9, 2))). It works alright, but I need to turn it into a date again, because I&nbsp;have to use it in a SP list as such.</p><p>&nbsp;I tried to google the question and tried several formulas found there, but none of them worked for me.</p><p>&nbsp;Can anyone please advise how to do this?</p><p>&nbsp;Thank you a lot!</p><p>&nbsp;Barbara&nbsp;</p>