-
Kully_kullyAsked on February 11, 2020 at 5: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.
-
roneetReplied on February 11, 2020 at 8: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.
-
Kully_kullyReplied on February 11, 2020 at 9:50 AMThe 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.
... -
BJoannaReplied on February 11, 2020 at 11:14 AM
Please check my reply on your other thread - https://www.jotform.com/answers/2157369