Incorrect date format with Google Sheets integration

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

    I have Google sheets integrated with my form:

    - Form = form https://form.jotform.co/SafetyJNJMech/prestart

    - Sheet = https://docs.google.com/spreadsheets/d/13fVvpCkIHcNv8FxWyjI8jj2b4h08sWBj3C2J4fXnUz8/edit?usp=sharing

    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: 

    Locale
    Australia
     
    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
    SafetyJNJMech
    Answered on February 06, 2018 at 05:12 PM

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

  • Profile Image
    Jed_C
    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 https://support.google.com/docs/answer/58515.

    1517966872date_format.png

    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
    SafetyJNJMech
    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.