Date Format in Google Spreadsheets

  • Profile Image
    Asked on December 06, 2012 at 05:18 AM

    I've linked my Jotform repsonses with a Google Spreadsheet and it all works great. However, I have a date field in my form and when the data gets sent to google it shows up in a hyphenated format (eg 6-12-2012). Google calendar doesn't recognise this as a date and therefore I cannot sort in chronological order. Is there any way to reformat the date into forward slash format (either via jotform or google spreadsheets) eg. 6/12/2012 so that it's recognised as being a date by the spreadsheet?

  • Profile Image
    Answered on December 06, 2012 at 07:20 AM

    Currently, there's no way in the form builder to reformat dates in the manner described. However, as a workaround, it is possible to use a script to both copy the values of the date field's inputs to a (preferably hidden) text box and convert the date to the Google Calendar format. However, since this solution would use a script, it would require embedding a copy of the form's full source into a web page and adding the script to the said page.

    I can clone your form, apply the aforementioned solution and get back to you with the requisite script, if you're okay with going the full source route. Please let me know your thoughts on that.

    In the meantime, I'll submit a ticket requesting that dates in submission records either contain slashes instead of hyphens or (better) that a date format switching tool be made available in the submission records page.

    I'll await your decision on using the form's full source.


    P.S. If Google Calendar recognises dates in the plain English format like
    January 1, 2013, the Birth Date Picker tool can be substituted for the DateTime one.

  • Profile Image
    Answered on December 06, 2012 at 08:54 AM

    Hi abajan,

    Thanks for the informative reply. It turns out that Google Spreadsheets does work with the Birth Date Picker format and it works as required so I'm quite happy using that until the regular date picker issue is resolved - saves us both some work. Cheers for your help!



  • Profile Image
    Answered on December 06, 2012 at 09:49 AM

    That's great news, Lee!

    Cheers :)


  • Profile Image
    Answered on July 31, 2013 at 06:47 AM

    Has this been fixed then?

    Because I see that the jotform's integration with Google Spreadsheets does not bring the date of submission in properly .. it is not seen as a date.

    So, everyone using your google speadsheet integration has no submission date sort capability


    Can this be fixed please

    Thanks Mark

  • Profile Image
    Answered on July 31, 2013 at 07:32 AM

    I believe this issue has been resolved already as you can see in the video below, I can sort the submission date without any problem.