Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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