NOW Function

Occasional Visitor

I'm a new user. Why does NOW() function return a a time 4 hours ahead?

2 Replies
NOW( ) returns current Date & Time ,, not only the Time,,, please match the time with the Date & Time displayed on Right bottom of the Status bar on screen,,, !!


If you are on desktop version it shall return system datetime of your computer. Most probably the same is for mobile versions, but I didn't test.


If you are on Online version, it returns datetime for the timezone which is set for Onedrive/Sharepoint site or where do you keep files online. That's not necessary your local time if you didn't care about regional settings for online storage.