How can I change date and timestamp to match my google spreadsheet entry?

  • Profile Image
    MikeOhren
    Asked on January 05, 2018 at 10:50 AM

    I have connected a form to a Google spreadsheet. This works fine, but the date and time stamps are off one hour on the spreadsheet entry. The time shows Eastern when I am in the Central time zone. 


    Where do I change the setting? 

  • Profile Image
    Sabbir
    Answered on January 05, 2018 at 11:07 AM

    You can change your date and time stamp from your account settings.

    Go to https://www.jotform.com/myaccount/settings

    You can also check this guide to know more:

    https://www.jotform.com/help/346-How-to-Change-Submission-Date-to-a-Different-Format-and-Timezone

    Let us know if you have any further query.

  • Profile Image
    MikeOhren
    Answered on January 05, 2018 at 11:43 AM
    ##- Please type your reply above this line -##
    Your request (5914) has been received and is being reviewed by our support staff.
    To add additional comments, reply to this email.
    ----------------------------------------------
    Jotformforum 1340020, Jan 5, 10:08 AM CST
    A new response has been received:
    Answered by Sabbir
    You can change your date and time stamp from your account settings.
    Go to https://www.jotform.com/myaccount/settings
    You can also check this guide to know more:
    https://www.jotform.com/help/346-How-to-Change-Submission-Date-to-a-Different-Format-and-Timezone
    Let us know if you have any further query.
    View this thread on browser » (http://www.jotform.com/answers/1340020-How-can-I-change-date-and-timestamp-to-match-my-google-spreadsheet-entry) Unsubscribe Thread (http://www.jotform.com/answers/1340020-How-can-I-change-date-and-timestamp-to-match-my-google-spreadsheet-entry?k=ba621381f95d322ec31c32b08257650d&unsubscribe=)
    1515168466
    --------------------------------
    This email is a service from MacMan.
    [ZQQZ98-8M92]
    ...