Forum Discussion
Calculated Column in SharePoint List with different TimeZone
I'm using a Calculation in a new column with just NOW() formula but I'm always getting the wrong time zone with 8 hours less. I already change the settings in the Site as well as in my Profile to UT...
Hi DaveMehr365, thanks for you answer.
Yes, as I said in the post, I already changed the regional settings at the site level, as well my profile regional settings to UTC and I'm still getting the same 8 hours less. I don't know any other setting that I could change. Perhaps I will try to create a ticket to Microsoft to understand this strange behavior.
Thank you,
Pedro
hi Pedro,
mind to share what is the root cause causing it ?
mind to share what is the root cause causing it ?
sin peow 5 I didn't get a solution for it (didn't create a Microsoft ticket yet because lack of time), I just added 8 hours to the date to make sure it is in the time zone I need. It's a dirty solution, but at least it works.
How did you add 8 hours to the date?
