My google Apps Script script returned a wrong timezone with Date(). What I expect is GMT+8 (because I live in Asia) but the script timezone returns GMT-5. Even the log time is not match.

Code:

let date = new Date(); 
Logger.log(date);

How can I change it from GMT-5 to GMT+8? Any help would be highly appreciated!

My google Apps Script script returned a wrong timezone with Date(). What I expect is GMT+8 (because I live in Asia) but the script timezone returns GMT-5. Even the log time is not match.

Code:

let date = new Date(); 
Logger.log(date);

How can I change it from GMT-5 to GMT+8? Any help would be highly appreciated!

• javascript
• google-apps-script

• Where's the code? – Cooper Commented Jan 14, 2021 at 4:16
• 1 Did you know that your spreadsheet and script can have different timezones? – Cooper Commented Jan 14, 2021 at 4:17
• minimal reproducible example.............. – Cooper Commented Jan 14, 2021 at 4:19
• Yes I am aware, I have already checked the timezone of my spreadsheet file at spreadsheet settings. Even my google calendar, the timezone set is GMT+8(Taipei). Code: function date() { let = date = new Date(); Logger.log(date);} – GenBreaker Commented Jan 14, 2021 at 4:26
• What's the timezone of the script project – Cooper Commented Jan 14, 2021 at 4:27

1 Answer 1

You can change the timezone of your script by modifying the manifest file.

This can be done by going to Project Settings and ticking the Show "appsscript.json" manifest file in editor.

Afterwards, just update the manifest file to this:

{
  "timeZone": "Asia/Taipei",
  "dependencies": {
  },
  "exceptionLogging": "STACKDRIVER",
  "runtimeVersion": "V8"
}

Note

Please bear in mind that you can modify this and input the timezone of your choice.