https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/116547.aspxFri, 23 Jun 2017 07:56:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116547kokosz0080https://www.infopathdev.com:443/forums/thread/116547.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116547<p>Thank you :) <br /></p>https://www.infopathdev.com:443/forums/thread/116529.aspxWed, 21 Jun 2017 15:10:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116529Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/116529.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116529<p>&nbsp;You bet. The default formula for the field bound to the textbox would be:</p><p> substring-before(<em><u>fieldwithdate</u></em>, &quot;-&quot;)</p><p>XML stores dates in yyyy-MM-dd format. The date picker or other control may display the date differently, but if you open an XML file saved from your form and look at the date field, it will be yyyy-MM-dd. If it includes time, it will be yyyy-MM-ddTHH:mm:ss&nbsp;</p>https://www.infopathdev.com:443/forums/thread/116528.aspxWed, 21 Jun 2017 09:08:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:116528kokosz0080https://www.infopathdev.com:443/forums/thread/116528.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=116528<p>Hello,</p><p>&nbsp;</p><p>&nbsp;I would like to know,</p><p>&nbsp;Is it possible to extact year from date picker into textbox ?</p><p>&nbsp;Thank you very much for your help,</p><p><br />Adam <br /></p>