Format Date Field - InfoPath Dev Sign in | Join | Help in Views InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Views » Format Date Field Format Date Field Last post 08-13-2009 07:20 PM by warrtalon. 2 replies. Page 1 of 1 (3 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 08-05-2009 10:45 AM sbernard Joined on 08-03-2009 Posts 21 Format Date Field Reply Contact I am successfully populating a date but when displayed is not formated correctly. The SP list is formated as "mm/dd/yyyy" ex 07/01/2009, Infoopath displays as "yyyy-mm-dd mm:hh:ss") ex 2009-08--01-01 00:00:00. I also have a percentage ex 50% displayed as 0.50000000. Thanks in advance Scott Filed under: format fields 08-05-2009 12:47 PM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Format Date Field Mark as Not AnswerMark as Answer... Reply Contact Hi -- if you look at the properties of the control, is there a 'Format' 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.... Hilary Stoupa 08-13-2009 07:20 PM In reply to warrtalon Joined on 12-13-2007 Denver, CO Posts 980 Re: Format Date Field Mark as Not AnswerMark as Answer... Reply Contact Yes, when receiving data from a SharePoint list, it will come in as a string even if it's a date field. You will need to format your control in InfoPath to display how you wish, and that goes for the decimal field, too. Did you try this yet? Clayton Cobb || SharePoint MVP || Clayton's SharePoint MadnessPlanet Technologies || Federal Partner of the Year (2005-2010) || SLG Partner of the Year (2010) Page 1 of 1 (3 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
I am successfully populating a date but when displayed is not formated correctly. The SP list is formated as "mm/dd/yyyy" ex 07/01/2009, Infoopath displays as "yyyy-mm-dd mm:hh:ss") ex 2009-08--01-01 00:00:00. I also have a percentage ex 50% displayed as 0.50000000.
Thanks in advance
Scott
Hi -- if you look at the properties of the control, is there a 'Format' 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....
Yes, when receiving data from a SharePoint list, it will come in as a string even if it's a date field. You will need to format your control in InfoPath to display how you wish, and that goes for the decimal field, too. Did you try this yet?