- sander_j4sAsked on July 06, 2012 at 03:30 AM
I found issues with the date format of jotform. Sometimes, jotform records a date like this:
And sometimes, jotform records a date like this:
Why does it do that? I have this form synchronized with google docs, and it results in this:
Also, for some weird reason, this is in the dd-mm-yyyy format, while ALL OTHER RECORDS are in the mm-dd-yyyy format. This is VERY CONFUSING. How am I to know if someone is entering a date like 'Januari 2', of 'February 1'? This makes it impossible to sync google docs to google calendar..
- ItalyTechAnswered on July 06, 2012 at 03:55 AM
Hi and thanks for contacting us. I report this issue to our developer. Can you indicate us your form ID please ? We let you know when we ave any news about this.
- sander_j4sAnswered on July 06, 2012 at 10:58 AM
thx for the reply
- JotForm SupportliyamAnswered on July 06, 2012 at 02:52 PM
Thanks for the information, sander_j4s. Once we have updates, we'll sure to let you know.
- sander_j4sAnswered on August 01, 2012 at 03:26 AM
Still no news on this?
- pinoytechAnswered on August 01, 2012 at 03:31 AM
Sorry to tell sander_j4s to tell you that this issue isn't resolve yet by our developer. Don't worry as soon as our developer fixed the issue we will inform you immediately.
Thanks for the patient!
- JotForm SupportNeilVicenteAnswered on March 05, 2013 at 08:55 PM
We are sorry for the really delayed updates, but I would like to let you know that I have applied a fix to this problem.
The date values are displayed as numbers on the submissions page when they do not follow the date field's format. For example, Jelle Polder mistyped the date (dd-mm instead of mm-dd).
I have also found a few other submissions on your form exhibiting this behavior:
The above example happened because month was written as '2' instead of '02'. The fix I applied should resolve this issue.
On the other hand, Jelle's case is obviously caused by user error, and the only way to rectify such is to edit the entry from the form's submissions page.
Hope this post helps.
- sander_j4sAnswered on March 08, 2013 at 04:55 AM
thanks for the update! Guess it's up to me to prevent the user from being able to make this mistake :)