Knowledge Base
How can we help?

Why is TODAY() formula returning the wrong value?

Ragic automatically runs daily recalculation in UTC ± 00:00 time zone, hence the inconsistency in the returned time value if you're located in a different time zone.

For example, configuring the execution time at 01:00 while you're located in UTC+8 will result in one day delay due to the 8-hour time difference.

The solution is to replace the referred TODAY() with TODAYTZ() so that the system will apply the time zone configured in your company settings when executing daily recalculation.

Top of Page
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com