Date Formats incorrect in Google Spreadsheet

  • Profile Image
    gemai
    Asked 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?

    Cheers

       Gema

  • Profile Image
    Charlie
    Answered 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.