FAQ
How can we help?
Full Site Search

Why Is the Today() Formula Returning the Wrong Value During Daily Formula Recalculation?

Currently, Daily Formula Recalculation is executed based on the UTC+0 time zone, which may lead to results that differ from the time zone set in the user account.

Example:

If your account is set to the "UTC+8" time zone and the daily formula recalculation time is "01:00", the system will still execute the recalculation based on "UTC+0". At "UTC+8 01:00", it is only "17:00" of the previous day in "UTC+0", so the TODAY() function will return the "previous day's date", making the result appear one day behind.

Solution:

Replace TODAY() with TODAYTZ() in your formulas.

TODAYTZ() returns the correct local date based on your company’s time zone setting, ensuring accurate results during daily formula recalculation.

Share your feedback with Ragic

What would you like to tell us?(required, multi select)


Screenshots to help us better understand your feedback:

Thank you for your valuable feedback!

    Start Ragic for free

    Sign up with Google

    Terms of Service | Privacy Policy