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/96549.aspxThu, 20 Mar 2014 15:29:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96549pitt23panther0https://www.infopathdev.com:443/forums/thread/96549.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=96549I was able to resolve the issue utilizing this useful blog post: http://blog-sharepoint.blogspot.com/2009/07/infopath-caml-date-time-format-in-when.htmlhttps://www.infopathdev.com:443/forums/thread/96545.aspxThu, 20 Mar 2014 14:34:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:96545pitt23panther0https://www.infopathdev.com:443/forums/thread/96545.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=96545Hello all - I have an InfoPath 2010 Form that has 2 fields - one is of type Date, and the other is of type Time. I am submitting the form to a SharePoint list, and would like to combine these 2 fields into a single date/time value to submit to a DateAndTime column in my SharePoint List. I have tried several ways to concatenate the 2 fields, but none seem to work. I started with a simply concat like this: concat(Date, "T", "Time") ...without any luck. My current attempt is: concat(msxsl:format-date(Date, "M/d/yyyy"), msxsl:format-time(Time, " h:mm tt")) But the submit fails when the SharePoint List to which I am trying to submit has a column data type of Date and Time. If I instead change its data type to Single Line of Text, it works - and it looks like a perfect date/time. Do/can I cast this concatenation to a Date datatype before submitting somehow? Thanks!