Wrong date format on google spreadsheet

  • Profile Image
    Asked on November 06, 2014 at 11:23 PM

    Anytime that I save time format in US form (mdy) it says "oops, something went wrong". What needs to be done? Also dates saved in my google spreadsheet are in Asia format (dmy). Please advise.

  • Profile Image
    Answered on November 07, 2014 at 01:26 AM


    Submissions dates passed on Google Spreadsheet are based on your account timezone. So if it's set on Asia time (format) currently, that will be used during the submissions. When you made changes on your timezone, it should reflect on the new submissions.

    The error you have reported usually occurs when you save the same time format that is already set on your account. I check your account and it's already on the desired time format so I assumed this was already resolved?

    I have also tested it on my account and it is working fine. If you're already on US time format, there's no need to set it again.

    Hope this information helps. If you have further questions, let us know.