Incorrect DateTime value in Google Spreadsheet Integration

  • Profile Image
    xumanudi
    Asked on April 30, 2015 at 09:03 AM

    in Google SpreadSheets 

    date error

    I just remove and add the integration.

    30-04-2015 09:14:09 30-04-2015
    30-04-2015 09:14:20 30-04-2015
    30-04-2015 09:15:37 30-04-2015
    30-04-2015 09:16:20 30-04-2015
    30-04-2015 09:16:59 30-04-2015
    30-04-2015 09:18:04 30-04-2015
    01-01-1970 00:00:00 01-01-1970
    01-01-1970 00:00:00 01-01-1970
    01-01-1970 00:00:00 01-01-1970
    01-01-1970 00:00:00 01-01-1970

     

     

    In JotForm the answers is correct

    Excel exported from JotForm is correct

     

     

     

  • Profile Image
    Charlie
    Answered on April 30, 2015 at 11:06 AM

    Hi,

    I've cloned your form and made a test integration to Google Spreadsheet, unfortunately, I can't seem to replicate the problem.

    Could you try the following:

    1. Remove the integration.

    2. Clear your form's cache and your browser's cache. Refresh the page and log back in.

    3. Before re-integration, re-select the Timezone and the Time Format in your account settings.

     

     

    4. After that, try re-integrating the Google Spreadsheet again, make sure to log in your account.

     

    See if that resolves the problem. We'll wait for your response.

    Thank you.