https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/47717.aspxThu, 08 Oct 2009 13:59:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:47717mark.marquis0https://www.infopathdev.com:443/forums/thread/47717.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=47717<p>Hello Ernesto, thank you for your reply. Making them text strings does not meet my business requirement. I have actually somewhat tried that using substring function and formatting accordingly, however as I mentioned, when I submit to SharePoint the date and time formats default back.</p>https://www.infopathdev.com:443/forums/thread/47708.aspxThu, 08 Oct 2009 12:41:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:47708ErnestoM0https://www.infopathdev.com:443/forums/thread/47708.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=47708<p>I would be interested to read about any solution you reach. I believe SharePoint and InfoPath simply store dates in different formats. Perhaps you could make some of these date/time fields text strings?<br /></p>https://www.infopathdev.com:443/forums/thread/47680.aspxWed, 07 Oct 2009 18:24:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:47680mark.marquis0https://www.infopathdev.com:443/forums/thread/47680.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=47680<p>I am working to take the infopath date and time formatted as &#39;2009-10-07T13:08:21&#39; to something more like &#39;10-7-2009 1:08 PM&#39; which will subsequently post back to a sharepoint list where I can perform calculation differences on various dates and times on a web enabled form.</p> <p><strong><u>The problem</u></strong>: In InfoPath now one cannot use one field to display both date and time unless you concat two different fields. However when you do so, those fields default to &#39;2009-10-07 13:08:20&#39; for example. Additionally, even with my individual fields that are formatted in InfoPath correctly for date as &#39;10/7/2009&#39; and time as &#39;1:12:50 PM&#39;, when posted back to sharepoint, they default back to this format (for date 2009-10-07 and for time 13:08:20)</p> <p><u><strong>My question:</strong></u> How can I get Infopath time and date concatenated to be in this format &#39;10/7/2009 10:49 AM&#39; in one field and have it retain that format when posted back to SharePoint?</p> <p>Note: currently in SharePoint I can use a calculated column to see the date/time difference on Create and Modify dates by using this function (=[Modify]-[Create]) which gives me a decimal number, which is what I want. Basically I am trying to do the same thing using infopath however am unable to retain the same date time format when publishing from infopath to sharepoint.</p>