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/92647.aspxSun, 01 Sep 2013 22:27:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92647Patrick Halstead0https://www.infopathdev.com:443/forums/thread/92647.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=92647<p>You could set a text field with the concat value and promote that field to your list or library and have the SP Designer reference that field instead.</p>https://www.infopathdev.com:443/forums/thread/92546.aspxTue, 27 Aug 2013 14:29:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:92546SPTech0https://www.infopathdev.com:443/forums/thread/92546.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=92546<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>