2

The Time Zone get from Date() in the script is correct, CEST (Central European Summer Time). But the time zone reported from View -> Logs menu in the script editor is PDT (Pacific Daylight Time)

That happens whatever standalone scripts and spreadsheets scripts.

This is an ad-hoc example code:

  Logger.log(Session.getActiveUserLocale());
  Logger.log(Session.getScriptTimeZone());
  var d = new Date();
  Logger.log(d.toLocaleString());

[17-09-12 01:50:46:566 PDT] es

[17-09-12 01:50:46:567 PDT] Europe/Paris

[17-09-12 01:50:46:568 PDT] 12 de septiembre de 2017 10:50:46 CEST

The Time Zone of the system is CEST. The Time Zone in Google Calendar and GMail of the google account is CEST too.

Any explanation?

P.S.

Related but not the same issue that theese questions:

MαπμQμαπkγVπ.0
  • 5,887
  • 1
  • 27
  • 65
Trimax
  • 2,413
  • 7
  • 35
  • 59
  • 2
    Hmm. Interesting. Hadn't noticed that before. I've just tried running a script with different user accounts and different script tz, and it looks like it's just a thing: the logging date is always PDT (maybe coz that's where Google's servers are???). – Andrew Roberts Sep 12 '17 at 11:51

2 Answers2

2

The log & the execution transcript seem to use US/PDT, which would be consistent with Google's home time-zone. However, if you export the logs the times are rendered in the script time-zone. Here's an example from a script that emails me an execution log.

Logs from Script Editor View>Logs

[17-09-12 18:28:40:915 PDT] Export file created: '[redacted].csv' (id: [redacted])
[17-09-12 18:28:43:274 PDT] Archive file created: '[redacted] - 20170913112841+1000 - export.csv' (id: [redacted])
...etc, etc.

Same section of the log from the emailed transcript:

Wed Sep 13 11:28:40 AEST 2017 INFO: Export file created: '[redacted].csv' (id: [redacted])
Wed Sep 13 11:28:43 AEST 2017 INFO: Archive file created: '[redacted] - 20170913112841+1000 - export.csv' (id: [redacted])
...etc, etc.

Annoyingly, while the exported logs are in the correct tz, they're in that non-ISO format Google so likes to foist on us.

Dean Ransevycz
  • 933
  • 8
  • 22
1

Go to 'File > Project properties > Info tab' and set the timezone.

If you can't see the menu bar with 'File' etc, you're using the new editor. You will need to click 'Use legacy editor' which will let you access the setting, then you can go back to the new editor.

JB_
  • 11
  • 1