- glidetalkAsked on January 14, 2016 at 04: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?
- JotForm UI DevelopermertAnswered on January 14, 2016 at 10:53 AM
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:
If you refer something else or need more information, please let us know.