79468063

Date: 2025-02-25 22:48:00
Score: 6 🚩
Natty:
Report link

Actually I am having the exact same problem but need to solve it.I checked my appdsscript.json and it is set correctly as well. I am using:

var details=[[events[i].getStartTime(), events[i].getTitle(), events[i].getStartTime(), events[i].getEndTime(), events[i].getDescription()]];

The time is one hour off once the dates hit the time change in April. however, to test I did this (ADDED A +1 TO MY getStartTime and Get EndTime):

var details=[[events[i].getStartTime(), events[i].getTitle(), events[i].getStartTime()+1, events[i].getEndTime()+1, events[i].getDescription()]];

I knew it would kind of blow up but what is displayed in my spreadsheet was interesting. This is what was in the cell:

Fri Jun 13 2025 18:00:00 GMT-0500 (Central Daylight Time)1

The time is actually correct! It dropped to GMT-5 instead of GMT-6. Is my problem in Google Sheets?

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Me too answer (2.5): I am having the exact same problem
  • Ends in question mark (2):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Stephen