Date Formatting changes on Google sheets

  • Profile Image
    travelclef
    Asked on April 08, 2021 at 05:24 AM

    Hi Team,


    I have been having date formatting issues with my forms integration with Google Sheets.


    I've specified my date entry in my form to be DD-MM-YYYY format. But when it integrates with my google sheets, the sheets doesn't detect it as that format, but instead as MM-DD-YYYY. And this messes up my formulas in google sheets.

    Is there any way I can make my form date entry to be DD-MMM-YYYY format permanently? Like 15-APR-2021?



  • Profile Image
    gerardw
    Answered on April 08, 2021 at 09:02 AM

    I cloned your form into my account to test, but could not replicate your issue. I got the correct output on Google sheets as DDMMYYYY:

    1617886686_606efdde61715_0804_6.png

    Probably, it could be a setting in your Google account which is automatically changing the date to MMDDYYYY.

    Please note that the data format cannot be changed automatically to 08-Apr-2021. It will only be shown as 08-04-2021. You will need to manually change the format after you export the data to another sheet. If you make any changes to the integrated sheet, your integration will break.

    Could you provide us a screenshot of how the date format is shown on your Google sheets? This guide will explain how to attach screenshots to this ticket: https://www.jotform.com/help/438-how-to-post-screenshots-to-our-support-forum

    Alternatively, please reintegrate Google sheets into your form and then check.