Google Spreadsheet: Submission date is passed incorrectly

  • Profile Image
    slonigiraf
    Asked on March 31, 2015 at 08: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.

  • Profile Image
    raul
    Answered on March 31, 2015 at 10:34 AM

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

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

    Let us know if the issue persists.
    Thank you.

  • Profile Image
    datasciadv
    Answered 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.
  • Profile Image
    lblanco3
    Answered 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
  • Profile Image
    Charlie
    Answered on March 31, 2015 at 01: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.