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

    Wrong date format on google spreadsheet

    Asked by rkrishna8 on November 06, 2014 at 11:23 PM

    Anytime that I save time format in US form (mdy) it says "oops, something went wrong". What needs to be done? Also dates saved in my google spreadsheet are in Asia format (dmy). Please advise.

  • Profile Image
    JotForm Support

    Answered by EltonCris on November 07, 2014 at 01:26 AM


    Submissions dates passed on Google Spreadsheet are based on your account timezone. So if it's set on Asia time (format) currently, that will be used during the submissions. When you made changes on your timezone, it should reflect on the new submissions.

    The error you have reported usually occurs when you save the same time format that is already set on your account. I check your account and it's already on the desired time format so I assumed this was already resolved?

    I have also tested it on my account and it is working fine. If you're already on US time format, there's no need to set it again.

    Hope this information helps. If you have further questions, let us know.