Google Spreadsheet Implementation changes

  • Profile Image
    Asked on March 02, 2015 at 01:16 PM

    Hello Support,


    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.




    Pablo Castellanos



  • Profile Image
    Answered 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.


  • Profile Image
    Answered 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.



  • Profile Image
    Answered 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.