Newbie Questionshttps://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)Re: convert string to datehttps://www.infopathdev.com:443/forums/thread/71129.aspxSun, 16 Oct 2011 15:44:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:71129Jimmy0https://www.infopathdev.com:443/forums/thread/71129.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=71129<p>translate(startDate, &#39;/&#39;, &#39;-&#39;) should do the trick.</p>convert string to datehttps://www.infopathdev.com:443/forums/thread/71125.aspxSun, 16 Oct 2011 03:06:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:71125MoBayTech0https://www.infopathdev.com:443/forums/thread/71125.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=71125I have string data type field named startDate with text in the format of YYYY/MM/DD, I need to convert the text to a format that I can use to set a data picker named ppDate without getting a validation error Is there a way to accomplish this using substring-before, substring-after and concat ?