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

    Date Formats incorrect in Google Spreadsheet

    Asked by gemai on November 29, 2015 at 10:47 PM

    Hi there

    For usability purposes, we have created a date field using 3 dropdown lists instead of the calendar. The form is integrated with a Google Sheet and the format of this date field when saved seems to be quite unstable.

    What can we do?



  • Profile Image
    JotForm Support

    Answered by Charlie on November 30, 2015 at 08:17 AM

    I cloned your form and checked it. I presume you are using the Birth Date picker widget?


    In my Google Spreadsheet, this is how it looks like:

    However, in my case, the separator used is "/" compared to other date values that are "-". In that case, you can change the whole column to your own format. You can follow this screenshot:


    I then made another test submission, see the second submission below has now the same format of the 1st submission which uses "-" in it.


    If I misunderstood your problem, perhaps you can share us a screenshot of it so that we can better assist you? We'll wait for your response.