Google Spreadsheet: Submission date is passed incorrectly

  • slonigiraf
    Asked on March 31, 2015 at 8:14 AM

    Jotform fills "Submission Date" column with something like: "42094.330729167" instead of something like "2015-03-12 08:16:05". This bug emerged about 1 or 2 month ago.

    Jotform Thread 543770 Screenshot
  • raul
    Replied on March 31, 2015 at 10:34 AM

    Can you please try to remove your current integration and create it again?

    Google Spreadsheet: Submission date is passed incorrectly Image 1 Screenshot 30

    I made a test on my side and the submission date was passed correctly to the spreadsheet.

    Google Spreadsheet: Submission date is passed incorrectly Image 2 Screenshot 41

    Let us know if the issue persists.
    Thank you.

  • datasciadv
    Replied on March 31, 2015 at 11:20 AM

    Tried. It fills rows with old submitions with right data. But any new submission after integration will be filled in Google Spreadsheet with bad date and time like in my example.
  • lblanco3
    Replied on March 31, 2015 at 11:54 AM

    Im having this same issue, i even tried to do a new form and the issue persists
  • Charlie
    Replied on March 31, 2015 at 1:14 PM

    Hi datasciadv

    I've opened a separate thread for your concern so that we can better assist you, please refer to this link: http://www.jotform.com/answers/544052

    Hi lblanco3

    I have also opened one for you, please refer to this link: http://www.jotform.com/answers/544050.

     

    We advise that users open their own threads for each question or concern that they have. We will address the threads accordingly.

    Kind regards.