Any idea why different dates? I know it is related...
# suitescriptf
francis
03/28/2019, 10:30 AMAny idea why different dates? I know it is related to timezone, but should it not be the same? since both don't have a specified time zone
c
cja
03/28/2019, 1:01 PMThis is not the answer to your question but both your dates specify Zulu (UTC) as the timezone
cja
03/28/2019, 1:03 PMCould you paste your code here? It'd be easier to play with
f
francis
03/28/2019, 3:13 PMThat was intentional, this is the result of .toISOString() in JavaScript
francis
03/28/2019, 3:13 PMI don't have this sample code saved anymore 😞
j
johnogle
03/28/2019, 4:17 PMI believe formatting a DATE will convert to the user preference or system preference time zone. At 4am if your time zone is the previous day, that’s why that is showing one day earlier.
johnogle
03/28/2019, 4:18 PMBut my head always hurts when I try to figure this out. My explanation doesn’t seem to fit with your logged results. For reference though, what is the time zone set to for your user during that session?
johnogle
03/28/2019, 4:19 PM(It looks like UTC-0300?)
johnogle
03/28/2019, 4:20 PMMaybe DATE and DATETIME are inconsistent? Like maybe DATE uses the account level time zone or the server level time zone, but DATETIME uses a user configured time zone?
r
Rehan
03/28/2019, 4:24 PMTry format.Type.DATETIMETZ
f
francis
04/02/2019, 6:24 PMIt was UTC-0300, DATETIMETZ work the same as DATETIME for me as well, only DATE generate that odd result
2 Views