Forum Discussion
Calculated Column in SharePoint List with different TimeZone
Hello pedroamaro
strange, i have created a new site with PST, now() will be showing the pst format, after set the regional settings in the site settings to utc +1, the correct time will be show.
The current site setting are the reference for this formula (=NOW()). Pls check the settings above.
Best, Dave
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
- sin peow 5Sep 13, 2023Copper Contributorhi Pedro,
mind to share what is the root cause causing it ?- pedroamaroSep 14, 2023Copper Contributor
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.
- rookietomiJun 08, 2024Copper Contributor
How did you add 8 hours to the date?