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.