https://www.infopathdev.com:443/forums/42.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/45846.aspxFri, 14 Aug 2009 02:20:59 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:45846warrtalon0https://www.infopathdev.com:443/forums/thread/45846.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=42&PostID=45846<p>Yes, when receiving data from a SharePoint list, it will come in as a string even if it&#39;s a date field.&nbsp; You will need to format your control in InfoPath to display how you wish, and that goes for the decimal field, too.&nbsp;&nbsp; Did you try this yet?</p>https://www.infopathdev.com:443/forums/thread/45471.aspxWed, 05 Aug 2009 19:47:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:45471Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/45471.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=42&PostID=45471<p>Hi -- if you look at the properties of the control, is there a &#39;Format&#39; button available? I have a sneaking suspicion that SharePoint may be giving you your data as strings, in which case you might need to use a formula to clean it up....</p>https://www.infopathdev.com:443/forums/thread/45457.aspxWed, 05 Aug 2009 17:45:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:45457sbernard0https://www.infopathdev.com:443/forums/thread/45457.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=42&PostID=45457<p>I am successfully populating a date but when displayed is not formated correctly.&nbsp; The SP list is formated as &quot;mm/dd/yyyy&quot; ex 07/01/2009, Infoopath displays as &quot;yyyy-mm-dd mm:hh:ss&quot;) ex 2009-08--01-01 00:00:00.&nbsp; I also have a percentage ex 50% displayed as 0.50000000.</p> <p>Thanks in advance</p> <p>Scott</p>