Ragic Logo
<< Whitelisting Ragic email IPs to avoid messages not getting throughTable of ContentsHow to change the field order on form page for mobile App? >>

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
<< Whitelisting Ragic email IPs to avoid messages not getting throughTable of ContentsHow to change the field order on form page for mobile App? >>
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Keep in touch:
Blog
Email
Facebook
Twitter
Ragic, Inc.
1-888-666-8037
Terms
Privacy