Evaluating datetime in table vs report time

[Mike_T]

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…

1. is NOW() using the local time to evaluate the value in the “If this is true” field?
2. this doesn’t feel like the best way to handle this, any better suggestions?