Incorrect date format with Google Sheets integration

  • Profile Image
    Asked on February 06, 2018 at 04:53 PM

    I have Google sheets integrated with my form:

    - Form = form

    - Sheet =

    Within the Google SheetIt was working fine up until this morning when it failed to update. I reset the integration, however, the dates now come in in the mm/dd/yyyy format and not the required dd/mm/yyyy format. 


    Within my account settings 

    I have my Time Format set to EU-Asia - DMY 


    Within my Google Sheets setting: 

    This affects formatting details such as functions, dates, and currency.
    Time zone
    (GMT+10:00) Eastern Time - Brisbane
    Your spreadsheet's history will be recorded in this time zone. This will affect all time-related functions.


    The date format within the actual form is as follows:

    1517956666Capture - Prestart Date Config

  • Profile Image
    Answered on February 06, 2018 at 05:12 PM

    The integration has stopped again this morning only 30mins after re-integrating it. 

  • Profile Image
    Answered on February 06, 2018 at 08:30 PM

    I checked your spreadsheet date and it shows as DD/MM/YYYY format. Please note that it uses your location or computer's default time format


    Please check if your locale time settings is your preferred time format. Let me know if that helps. 

    Regarding the integration, did you make any changes / edits to your spreadsheet after integration?

  • Profile Image
    Answered on February 07, 2018 at 06:19 PM

    Thank you Jed_C, I beleive the times were incorrect due to the person's computer time being set wrong. The times on the report changed after I entered into the original submission and resubmitted.