Segment building - Contract End Date > today()

[akwankl]

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,

[birthariyamayank · Accepted solution]

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):

[akwankl]

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

Thanks,

[birthariyamayank]

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).