So, I'm scratching my head on something that shoul...
# suitescriptd
darrenhillconsulting
09/09/2021, 1:46 PMSo, I'm scratching my head on something that should be easy. I've got a date/time from the user (using a date/time picker) that will be in the User's timezone preference. And I need to convert that time to GMT. I'd prefer not to include
momentN/formatm
mrrob503
09/09/2021, 1:53 PMI run into that sometimes, I think you have to actually make a new date using the difference in timezone, like this
mrrob503
09/09/2021, 1:53 PM Copy code
const gmtDate = new Date(pacificDate.getTime() + pacificDate.getTimezoneOffset() * 60 * 1000);b
battk
09/09/2021, 1:56 PMkinda depends on what format you want your string in
battk
09/09/2021, 1:57 PMDate.prototype.toUTCString will convert the Date to a string in the gmt timezone
battk
09/09/2021, 1:57 PMthough its usually more common to use Date.prototype.toISOString
battk
09/09/2021, 1:59 PMthere are a bunch of utc related getters if you want to format the string yourself
d
darrenhillconsulting
09/09/2021, 2:43 PMArg. Why won't my brain understand this. The datestring I'm starting with ISO and in the timezone of the User pref. So, are we saying that if I new Date(userdatestring).toUTCString(), I should be good?
darrenhillconsulting
09/09/2021, 2:44 PMWhat confuses me is that the ISO String doesn't contain a timezone, so how does the Date object know how many hours to +/-? Or is that magic?
b
battk
09/09/2021, 2:45 PMDate represent a number (milliseconds since unix epoch)
s
Sciuridae54696d
09/09/2021, 2:45 PMthe birth of computers is universal. 1/1/1970
b
battk
09/09/2021, 2:47 PMthat number can be represented by different strings
battk
09/09/2021, 2:47 PMin different timezones
battk
09/09/2021, 2:49 PMDate's have an offset representing a timezone (in server suitescript that is basically always Pacific timezone's offset)
battk
09/09/2021, 2:49 PMand does the math to generate to generate your datetime string
battk
09/09/2021, 2:50 PMby default, Date's support generating strings for their timezone and gmt
battk
09/09/2021, 2:50 PMmodules like N/format have to do their own math to generate strings for other timezones
battk
09/09/2021, 2:51 PMsame thing in reverse if going from a string to a Date
s
Sciuridae54696d
09/09/2021, 2:52 PMI guess also, there is a section on date/time fields and how NetSuite automatically accepts it as utc, then converts it to user time
@darrenhillconsulting Maybe this is what you're looking for?
https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1499269203.html
b
battk
09/09/2021, 2:52 PMtoISOString does contain a timezone, with the Z representing Zulu time, which is the same as UTC and GMT
4 Views