Google Spreadsheet Integration - Date Not Seen As Date

  • Profile Image
    markashton
    Asked on July 31, 2013 at 06:54 AM

    Hi,

    Jotform integrates with Google Spreadsheets.

    The date does not come in as a date format ... seen as text

    What gives ... I see people have  advised you on numerous occasions ...

    http://www.jotform.com/answers/133139-Google-Spreadsheets-new-submissions-at-TOP-of-spreadsheet-and-Tabs

    http://www.jotform.com/answers/154580-Date-Format-in-Google-Spreadsheets

    I could go on ... but they'll do.

    Can you advise me on this please?

    Thanks Mark

  • Profile Image
    KadeJM
    Answered on July 31, 2013 at 09:43 AM

    Hi Mark, I tested this with a brand new form to check both the submission date and also the date field. Both dates during my testing phase seem to come through in the appropriate format. I saw my colleagues responses in those threads where the date seemed to be working as it should thus a Ticket Reporting it was never needed to be escalated to our Developers. Also, unless I somehow overlooked it I didn't see anything pointing to what you speak of since it appears that this is already working properly. If you are still having this issue can you please provide us with further details and a screenshot or sample of what you are seeing for the date format if it is incorrect? You may want to try clearing your form cache then reintegrating to see if that helps.