Configure a query to only show people x days prior a given date

rafaelc35759395

19-06-2019

I am kind of stuck regarding how to apply a filter to a query to show only people based on the following workflow:

Scheduler > Query (send em email to clients 2 days in advance to their trip date) > Delivery

I want to send an email today to everyone within my recipient folder departing in two days (departure date is an expression within my schema) wishing clients a good journey.

How should I structure the filter within a query to meet this criterion?

Thank you in advance,

Rafael

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

19-06-2019

Hi,

Put this in the filter:

DateOnly(GetDate()) equal to DateOnly(SubDays(@departureDate, 2))

DateOnly() is on @departureDate only if that's of type datetime- remove if date.

Also check nms:broadLogRcp to filter out recipients who've received the delivery, in case someone restarts the workflow.

Thanks,

-Jon

Answers (0)