Hi, I’m trying to create a current time with =Now() and =NowUTC() for the UK time zone but GI gives me the same result for both functions. system not calculate daylight savings.
I ran the GI at 11.40 am local time but GI gave 10.40 am for both =Now() and =NowUTC().
Please help to fix this.
Thank you.
Desh
Best answer by dwijebandara26
Hi Naveen thanks for the information but in GI view both Now and NOWUTC show the same time.
I have found the following information.
“Usually the datetime fields in Acumatica ERP are stored in UTC time in the database and displayed in the user time zone in the UI. So, whenever you retrieve a datetime field in the GI you can expect that it is already converted to the current user time zone. However, if you use a datetime field value in a formula the value will be used as is (without conversion).”
So I used the full data field in the GI.
Thank you,
Desh
+20Hi
+20
Hi Naveen thanks for the information but in GI view both Now and NOWUTC show the same time.
I have found the following information.
“Usually the datetime fields in Acumatica ERP are stored in UTC time in the database and displayed in the user time zone in the UI. So, whenever you retrieve a datetime field in the GI you can expect that it is already converted to the current user time zone. However, if you use a datetime field value in a formula the value will be used as is (without conversion).”
So I used the full data field in the GI.
Thank you,
Desh
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
