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: Date of submission is passed as a number instead of as a date

    Asked by tgbam on April 04, 2015 at 05:32 PM
    I'm experiencing the same problem!
  • Profile Image

    Answered by davibiel on April 04, 2015 at 06:17 PM

    I am awaiting this solution. Who is hindering me systematically
  • Profile Image
    JotForm Support

    Answered by jonathan on April 04, 2015 at 07:59 PM

    @ tgbam

    Have you already tried refreshing the integration?

    You can do this by following this steps

    1. Remove the existing Google spreadsheet integration


    2. Saved the Form

    3. Redo the integration process


    4. Complete the integration process and Saved the form again.

    Check the generated google spreadsheet if Submission dates are now corrected.

    You can also make a test submission just to be sure that the new submission/s will have the proper submission date format in Google spreadsheet.

    Please let us know if issue remains even after doing all this procedure already.




  • Profile Image

    Answered by alp_deniz on April 10, 2015 at 02:46 PM


    Google integrations were under heavy maintenance lately as we are constantly trying to improve user experience, and this was an unfortunate, temporary issue and it should be fixed after re-integration.

    Thank you for your understanding.

    Kind regards