-
Bruce HamiltonAsked on April 22, 2024 at 11:13 AM
I have set up the date field on my form with the format DD-MM-YYYY, but when I download the submissions to csv, and then open it in Excel, the date field is displaying MM/DD/YYYY which means that some entries are being treated as text and others are displaying incorrectly. e.g. a date of birth which is 4th September 1976, was entered in the form in the three field boxes as 04 09 1976, but it is showing as 9/04/1976 and another date 21st November 1977 (entered as 21 11 1977) is showing as 11/21/1977. Changing the date format in Excel (for example to d-mmm-yyyy) does not fix it. The first date converts to 9-Apr-1976 (which is incorrect) and the second date doesn't convert at all. How do I fix this problem?
-
Kenneth_PReplied on April 22, 2024 at 11:59 AM
Hi Bruce,
Thanks for reaching out to Jotform Support. I’m sorry that this is happening. I see that you'd like to change the date format to DD-MM-YYYY, and this can be easily done by adjusting the settings in your Jotform Tables. Let me show you how:
- In Form Tables, click the Column date drop down.
- Scroll down and click Date Format.
- Select your desired Format.
Take a look at the screenshot below to see my results:
Keep us updated and let us know if you need any more help.
-
brucehamiltonReplied on April 23, 2024 at 12:10 AMThanks. That has worked. I changed the format for each column with dates.
*Is there a global setting that will do the same or is it something that has to be done for each individual date column?
* Can this format be set as a default for any future forms or is it something that has to be done for each form?
Regards,
Bruce.
w: 07 3289 2888
m: 0418 718 096
email: bruce.hamilton@bcf.org.au<bruce.hamilton>
Large file upload link: https://www.hightail.com/u/BruceHamilton
</bruce.hamilton>... -
Rene JotForm SupportReplied on April 23, 2024 at 2:41 AM
Hi Bruce,
As for your other questions, I've moved that to a new thread. You can check that out here.
Let us know if you have any other questions.