Configure a query to only show people x days prior a given date | Adobe Higher Education
Skip to main content
R
rafaelc35759395
Level 2
June 19, 2019
해결됨

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

  • June 19, 2019
  • 1 답변
  • 1132 조회

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

    이 주제는 답변이 닫혔습니다.
    최고의 답변: 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 답변

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity Advisor답변
    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

      약관 및 조건Accessibility statement

      Loading footer...