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 UTC but it didn't solve this problem.
For now the workaround was used was just to add 8 hours (8/24) to the date, but I would like to avoid that.
Is there any other setting I should look at to be able to get the correct timezone for the NOW() formula?
Note: The goal is not to just use the NOW() formula in the Calculation (so it's not useful to use the Modified column), I'm just explaining the main issue which is related
7 Replies
Did you use a formula to add the 8 hours? I'm really struggling with this very issue right now and can't for the life of me get it fixed.
- This is an old thread, but I wanted to update you that I am facing the same issue. I set Eastern Time in my regional settings, but NOW() is returning me three hours less (Pacific Time). In your case, eight hours is the difference between UTC and PST. I believe you were using SharePoint Online, like me. FYI, I am using SharePoint Online on Microsoft 365 GCC.
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 ?
