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.
Google Spreadsheet Implementation changesAsked by Thinkbright on March 02, 2015 at 01:16 PM
I have a question. Since February 18 I've noticed that dates in our google sheets - jot form linked spreadsheets are getting stored as text instead of dates e.g. ('2015-02-18 18:28:39 instead of 2/18/2015 18:10:19) Is this a bug? It is causing us a lot of trouble in our implementations.
I believe you are referring to the Submission Date column in your Google Spreadsheet?
This not a bug. This is the predefined format (by Jotform) used when storing the exact time a submission was done. This time can not be adjusted but your can add a field to your form that could provide similar data. Is that a possible workaround for you?
You can use the DateTime field under your Quick Tools tab to store similar data in the order that you desire.
I hope this information helped. Do let us know if further assistance is needed.
Thanks for your answer. It's very interesting since somehow google spreadsheets is not handling the date as a date anymore. Maybe it's a change on their side. Anyways, I found a workaround using iferror + DATEVALUE.
Great! I am glad you were able to find a sufficient workaround. Please don't hesitate to contact us if further assistance is needed.