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

Avatar

Avatar
Validate 1
Level 1
rafaelc35759395
Level 1

Likes

2 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
rafaelc35759395
Level 1

Likes

2 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
rafaelc35759395
Level 1

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)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

976 likes

Total Posts

1,096 posts

Correct reply

514 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
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)