Hello, I'm trying to create a query that will look at the event date of a recipient who received a Welcome Email but did not open it in the last 24 hours. For example on 8/14 I want to send another email to recipients who were sent the first email on 8/13 but did not open it. I'm having a problem with calculating the event date. If I hardcode the date I can get it to work. but when I use 'current date minus n days' the query just spins and doesn't produce a result.
Thank you for your prompt reply. I removed the additional 'recipient delivery log exist' line and ran it again, but no dice. the query is staying in limbo with the gear at the top running. Like you mentioned the query regarding the event date seems correct. in fact, when I hard code the dates I get the recipient population I'm looking for. this only happens when I try using a function.