Change of Date format

  • Profile Image
    Kully_kully
    Asked on February 11, 2020 at 05:41 AM

    Hello.  Please could you advise how the Excel submission date format can be amended?  We changed the forms to dd-mm-yy however, the Excel data is still showing mm-dd-yy.


    Thank you.

  • Profile Image
    roneet
    Answered on February 11, 2020 at 08:56 AM

    To be able to change the Time format on the submission page, you would be able to change it via the account settings:

    Guide: https://www.jotform.com/help/346-How-to-Change-Submission-Date-to-a-Different-Format-and-Timezone

    Hope this helps!

    Thanks.

  • Profile Image
    Kully_kully
    Answered on February 11, 2020 at 09:50 AM
    The submission date is correct. On the jotform it’s the Date of Birth I am having problems with. So on jotform a DOB is 06/05/2007 excel down load and it says 05/06/2007 for example. I need to calculate ages in the excel spread sheet which are obviously incorrect.
    ...
  • Profile Image
    BJoanna
    Answered on February 11, 2020 at 11:14 AM

    Please check my reply on your other thread - https://www.jotform.com/answers/2157369