SharePoint Integrationhttps://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)Re: Concat is displaying military time in the email that i produce from SP Designerhttps://www.infopathdev.com:443/forums/thread/92654.aspxSun, 01 Sep 2013 22:42:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92654Patrick Halstead0https://www.infopathdev.com:443/forums/thread/92654.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=92654<p>Please do not post the same question in separate locations. I answered your other post.</p>Concat is displaying military time in the email that i produce from SP Designerhttps://www.infopathdev.com:443/forums/thread/92528.aspxMon, 26 Aug 2013 19:30:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92528SPTech0https://www.infopathdev.com:443/forums/thread/92528.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=92528<p>I am using the following formula.&nbsp; concat(date, &quot; at &quot;, start_time, &quot; to &quot;, end_time)&nbsp; To get a date at the start time to end time.&nbsp; It is showing the correct time in the infopath form and on the sharepoint list but when i try and write it to the sharepoint designer created email it is showingi n military time.&nbsp; How can i get it to show as hh:mm AM/PM not military time?</p>