Where does the timezone GMT-0400 (EDT) come from? Is it a server or something?
A google sheet as timezone which can be configured. I think that would be more accurate to use if possible.
when I try to convert the dates to my timezone I can end up with an entry that spans over two days.
SpreadsheetApp.getActive().getSpreadsheetTimeZone()
Where does the timezone GMT-0400 (EDT) come from? Is it a server or something?
A google sheet as timezone which can be configured. I think that would be more accurate to use if possible.
when I try to convert the dates to my timezone I can end up with an entry that spans over two days.
SpreadsheetApp.getActive().getSpreadsheetTimeZone()