Hi all, We have a service that fetches the reviews...
# suitecommercep
Paper Plane Netsuite Group
07/22/2020, 12:42 PMHi all, We have a service that fetches the reviews by a particular user and displays them. The issue is with the Date created field. The field is not returning the exact value thats stored in backend. For example if in backend its "7/22/2020 4:55 pm" but the service response returns "7/22/2020 4:25 am"
s
Steve Goldberg
07/22/2020, 1:02 PMI believe this depends on the time zone of the user, no?
p
Paper Plane Netsuite Group
07/22/2020, 1:05 PMThe date saved in backend reflects the actual date and time of the user, so when the review for the same user gets displayed, it should have the same date and time right? @Steve Goldberg
s
Steve Goldberg
07/22/2020, 1:07 PMThe date will likely be stored in a date format that reflects UTC. However, like some quantum experiment, its relative value will be determined by who is observing it.
🤣 1
Steve Goldberg
07/22/2020, 1:08 PMIf you've logged in to the backend as a user whose timezone is set to an Indian timezone then it will look different to someone who is looking at with a European timezone
Steve Goldberg
07/22/2020, 1:08 PMI would check what timezone the customer is set to
p
Paper Plane Netsuite Group
07/22/2020, 1:37 PM@Steve Goldberg from where can I cehck the customers timezone
Paper Plane Netsuite Group
07/22/2020, 1:37 PMI am in india and the backend timezone is also set to that, so at both places the date time should reflect the same value
s
Steve Goldberg
07/22/2020, 1:39 PMGood question. I think that it's probably actually not possible to see/set/change timezone on a per-customer level.
Steve Goldberg
07/22/2020, 1:40 PMOK, I don't actually know how you might solve this
p
Paper Plane Netsuite Group
07/22/2020, 1:40 PMOkay, do let me know if you find something. Thanks anyways @Steve Goldberg
k
kkennedydesign
07/22/2020, 3:43 PMThere is a date and time company preference I believe that may help you synch it up
👍 1
e
eminero
07/22/2020, 5:37 PM@Paper Plane Netsuite Group I have not deal this issue in SCA but from the ERP side I have used moment.js to solve this problem of the time zone. Dates in NetSuite are a pain. Check the company preference timezone to match that timezone.
👍 2