date format - InfoPath Dev
in

InfoPath Dev

date format

Last post 06-21-2013 07:33 AM by ErnestoM. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 06-21-2013 03:44 AM

    date format

    i'm getting one strange sort of problem, in form i have field called date (DD/MM/YYYY) format but when i add same field as part of con-cat to update history field format change as YYYY-MM-DD. date picket field format :21/06/2013 after using same field in con-cat format show 2013-06-21. any suggestions. thank you in advance
  • 06-21-2013 06:16 AM In reply to

     Please check the data types of the fields. If the data type is set to date, the format would be 2013-06-21. The format dd/mm/yyyy would probably come from a text field only, not an XML date.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 06-21-2013 07:22 AM In reply to

    ErnestoM Thank you so much for the reply. date picker field format is set as dd/mm/yyyy and it does show date in 21-06-2013 format but when history date field is updated using con_cat option date format changes. please have a look at the attachment.
  • 06-21-2013 07:33 AM In reply to

    A date picker can display a date in various formats, but an XML form stores date in a generic format. That's the format you're seeing in the history field. I think what you're seeing is expected. If you save the form to your local drive, and then open it in Notepad, you'll see that the date picker field is actually storing the same date shown in the history section.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.