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...
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
- hi Pedro,
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.
