I’m not sure which timezone appsheet is using to evaluate my report trigger.
i have a table with a row for every 10:30am and 6pm of every day of the year. So 730 rows. Every 10:30pm and 6am of every day I want the report to trigger to evaluate the row that is 36 hours ahead or NOW()+1.5. I have it setup to trigger:
If this is true…
AND([Sail Date]>(NOW()+1.4),[Sail Date]<(NOW()+1.6),ISNOTBLANK([Booked By]),ISBLANK(Confirmed By]))
Basically…if the row is more than 1.4 days ahead and less than 1.6 days ahead, someone has booked the time and no one has confirmed it…do… whatever.
Is it because NOW() is using UTC so when the row is evaluated NOW()+1.4 and +1.6 won’t find anything between them?