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,
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.