Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

rafaelc35759395
Level 2
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
wodnicki
Correct answer by
Community Advisor
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
wodnicki
Correct answer by
Community Advisor
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