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...
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.