Google Sheet Integration: Why date picker field is exporting as text instead of numeric?

  • Jain_Sagar
    Asked on February 17, 2021 at 7:27 AM

    When submitting a form, datepicker is exporting dates as text to google spreadsheets. 

    Can you please help. I have tried other date widgets too but can't find a solution.

  • Zahra_S
    Replied on February 17, 2021 at 8:18 AM

    Hi there!

    We apologize for the inconvenience.

    I created a form and integrate it with Google Sheet. I used the Date Picker from basic form elements.

    1613567820 602d174ceb796 Screenshot 10

    When I submit the form, the date was exported to the sheet properly.

    Please see the screencast below:

    1613567440 602d15d075e6b date picker Screenshot 21

    Can you please remove the date picker field and add it again? If the issue persists, please share the form link so we can test it on our end.

    Feel free to contact us if you need further assistance.