JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
When I export data to an excel or csv spreadsheet, the date format is out of syncAsked by amy_oakley20 on October 05, 2015 at 08:00 PM
- The date format in the column looks like this
06 22 2015 06 09 2015 06 05 2015 05 27 2015 05 27 2015 05 15 2015 05 15 2015 12 01 2014
Because of this, I cannot format the cells to change the date format. It also means that it is not picking up the date ranges that I am setting for selected data to track. Can you please advise what to do???
Still waiting on an answer to this thread? Support have answered questions from other people after my thread. I am waiting on a response so I can figure out whether JotForm can fix this issue or I need to move to another platform.
Please disregard my reply on your other post. This has the details I asked there. :)
It is clear to me now that you are referring to the downloaded submissions on excel. However, I can't seem to reproduce the problem. Both the submissions date and the date field appears to have a delimiter which appears to be a correct date format when opened on excel. I have tested this with my form.
I have also managed to change it's format.
If you are having troubles with your form, please let us know which form so we can check it here. Thanks!