How can I get the Date & Time of a Message rec...
# suiteqlb
burkybang
03/30/2023, 6:48 PMHow can I get the Date & Time of a Message record that matches what it shows in the UI?
burkybang
03/30/2023, 7:52 PMI'm getting closer. I've discovered that the time zone seems to be UTC. I tried converting that to the user's time zone, but it's still off by one because of daylight savings time.
I tried replacing TZD with TZR, but that threw an error.
c
Clay Roper
03/30/2023, 7:56 PM@burkybang Make sure you're getting the user's time zone and not the server's time zone - from what I recall, SYS is the server time
b
burkybang
03/30/2023, 7:57 PMOkay, sure. In this case the user and company have the same time zone. How can I get the user's time zone abbreviation?
c
Clay Roper
03/30/2023, 8:08 PMThe server time zone is where Netsuite's servers are, independent of company or user location. Try
CURRENT_DATEb
burkybang
03/30/2023, 8:09 PMOkay, that works for the user's time zone. Thanks. Now I just need to solve getting the date/time from that field in the same time zone as the UI.
burkybang
03/30/2023, 8:10 PMRight now, I have figured out how to get the time zone abbreviation, but it returns EDT, which is correct; however, when used to convert the time, it does not match the UI.
c
Clay Roper
03/30/2023, 8:11 PMHow are you using it to convert the time?
b
burkybang
03/30/2023, 8:11 PMSee my screenshot in my comment above. I'm using NEW_TIME()
👍 1
c
Clay Roper
03/30/2023, 8:16 PMIt might be related to EST vs EDT - Mar 10 was before the switch from EST to EDT. Can you use
FROM_TZb
burkybang
03/30/2023, 8:16 PMOhh, true
c
Clay Roper
03/30/2023, 8:16 PMI had a suspicion DST was related, and a Google turned this up.
b
burkybang
03/30/2023, 8:19 PMDoesn't FROM_TZ() go the opposite direction? It converts a timestamp from a time zone to GMT
burkybang
03/30/2023, 8:19 PMI need the other way around
burkybang
03/30/2023, 8:53 PMI think I figured it out
burkybang
03/30/2023, 9:42 PMFixed bug with am/pm
👍 1
c
Clay Roper
04/04/2023, 2:10 PMGlad to hear you got it 🎉 @burkybang
4 Views