What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

    Google Spreadsheet: Submission date is passed incorrectly

    Asked by slonigiraf 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

    Answered by raul 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

    Answered by datasciadv 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

    Answered by lblanco3 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
    JotForm Support

    Answered by Charlie 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.