AND statement based on status and submission date

[Scooter093]

I want to implement a Bot that sends out an email if the following conditions are met

Status = "1. New" AND Submission Date = Submission Date + 24 or 48 Hours

It's the Submission Date condition that has me confused.  How can I define some period after the submission date that a reminder email needs to go out?

Thanks,

Sean

[Markus_Malessa · Accepted solution]

Lets say you run a bot at 22:00 hours every day where you would want to capture every record with a timestamp between 21:00 hours yesterday and 21:00 hours today. Your AND() comparison would be similar to this:

AND([Submission Date] >= (TODAY() - 1) + "021:00:00", [Submission Date] < TODAY() + "021:00:00")

[Scooter093]

Thank you, Markus!

I was able to learn from your example and apply it to what I'm doing now.

Regards - Sean