TODAY() shows next day data at 8pm

This should be a quick solve, but my TODAY() expression begins showing the next day data at 8pm. Is there an internal clock that needs to be set in Appsheet?

0 5 129
5 REPLIES 5

Check your browser or phone locale / time zone settings

ok will do. But if it was running a report at 8pm, and the report was only for rows where the start_date = TODAY(), where does it find the date? it donโ€™t think it would be from a browser, because which browser would it grab it from?

Steve
Participant V

3X_4_2_4220243732fa26d7a23ef94f7e56440ee68e59fd.png

This is not the issue. Its firing at the proper time. the issue is the filter condition. When it fired last night at 8pm, I wanted to send it with data from todayโ€ฆ

but TODAY() gave me Tomorrow. So I rewrote it as TODAY()-1. My question isโ€ฆ something is off with my TODAY() where at 8pm, it thought I was already into tomorrow. Maybe my appsheet is set to UTC.
3X_2_7_27128917201d003e226a952a07553bdc47c1c6c7.png

Yeah, I would guess the serverโ€™s time zone is being used.

Top Labels in this Space