-
glidetalkAsked on January 14, 2016 at 4:30 AM
I have a form that includes the standard date/time picker with the format set to ddmmyyyy.
when passing it to google sheets (into a date formatted column) the value appears with a ' in front of the date so it's treated as text rather than a date.
Any idea why?
-
mert JotForm UI DeveloperReplied on January 14, 2016 at 10:53 AM
Hi there,
I tried the clone of your form on "Google Spreadsheet" and didn't find anything like " ' " in front of the "DateTime" field value. Please, see it from the below:
Also, you can re-format the column by using the following guide:
https://support.google.com/docs/answer/56470?hl=en
If you refer something else or need more information, please let us know.
Thanks.