Segment building - Contract End Date > today() | Community
Skip to main content
A
akwankl
Level 6
June 28, 2023
Solved

Segment building - Contract End Date > today()

  • June 28, 2023
  • 1 reply
  • 955 views

Hello,

 

Apologies in advanced as this seems to be a simple question that's escaping my head. I have an attribute where it contains the contract end date of each profile, and I am trying to create a segment that target customers that are still in contract, ie. their contract end date is greater than today. How do I do that?

 

Thanks,

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 birthariya

One way is to use PQL where you can compare the contract date and today's date (Profile Query Language)

Another not-so-great way to put this is (Read Birth Date as  Contract Date):

 

1 reply

B
birthariyaAccepted solution
Level 3
June 28, 2023

One way is to use PQL where you can compare the contract date and today's date (Profile Query Language)

Another not-so-great way to put this is (Read Birth Date as  Contract Date):

 

A
akwanklAuthor
Level 6
June 28, 2023

Thanks @birthariya, I resolved to using the "In Next" method too. Though, for the PQL suggestion, how do I use that in the segment builder?

 

Thanks,

B
birthariya
Level 3
June 28, 2023

PQLs are not meant for UI/Segment Builder, unfortunately.
We have to use API endpoints to define segment definitions when using PQL. 

Such segments can not be created/edited using AEP Segment Builder UI. (Not a marketer-friendly way).

 

 

 

Terms & ConditionsAccessibility statement

Loading footer...