Configure a query to only show people x days prior a given date | Community
Skip to main content
R
rafaelc35759395
Level 2
June 19, 2019
Solved

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

  • June 19, 2019
  • 1 reply
  • 1132 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    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

    1 reply

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    June 19, 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

      Terms & ConditionsAccessibility statement

      Loading footer...