I’ve built a report that is triggered everyday at the same time 10:30am Pacific Standard Time
In the “If this is true…” field:
AND([Session Date]>(NOW()+2.5),[Session Date]<(NOW()+3.5),ISNOTBLANK([Booked By]),ISBLANK([Confirmed By]))
My table is setup with a row for everyday, Session Date column is DateTime type. e.g. 1/29/2021 10:30:00
I’m trying to send out a reminder email to the user in the BookedBy column that has reservation 3 days from now (72 hours).
My questions are…
- is NOW() using the local time to evaluate the value in the “If this is true” field?
- this doesn’t feel like the best way to handle this, any better suggestions?