I’m relying on using the TODAY() formula to mark fields true or false if a date = today. The trouble is, the formula is not working as I expect. Although I can clearly see the date is today, the formula shows FALSE, and if I change the date to yesterday, it becomes TRUE.
I am based in Asia, so I expect there is a conflict of timezones somewhere?
Does anyone know how I can correct this?