The following Google Apps Script is a quick example of a recent improvement I have learned when handling dates (example blog post of the old method).
Rather than defining the timeZone as GMT (or GMT+1 for daylight savings) in the 'formatDate' property, I will be starting to use 'getScriptTimeZone' when it is not bound to a Google sheet. This eliminates the issue of the script becoming inaccurate by 1 hour when the clocks go back/forward, as it will pick up the time zone from when/where the script is being run.
Get script time zone for a date.gs
No comments:
Post a Comment