- ThinkbrightAsked 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.
- SeanAnswered on March 02, 2015 at 02:21 PM
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.
- ThinkbrightAnswered on March 02, 2015 at 02:32 PM
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.
- SeanAnswered on March 02, 2015 at 02:38 PM
Great! I am glad you were able to find a sufficient workaround. Please don't hesitate to contact us if further assistance is needed.