Audience Conditions for Dates in Past and Future | Community
Skip to main content
T
trojan_horse
Level 3
May 22, 2025
Solved

Audience Conditions for Dates in Past and Future

  • May 22, 2025
  • 2 replies
  • 533 views

Hi,

I have a time-sensitive request and would appreciate any quick guidance.

 

I’m trying to build an audience with a condition that checks if a user's start_date is before today and end_date is after today - essentially qualifying users who are currently active. However, I couldn’t find an option in the audience builder to compare dates directly against “today.”

 

Does anyone have recommendations on how to implement this?

 

Thanks in advance!

Best answer by AnkitJasani29

Hi @trojan_horse ,

Use the Now token in the UI

Drag your start_date attribute onto the canvas.

Set the operator to is on or before and, in the date picker, choose Now (this represents the current timestamp).

Drag your end_date attribute onto the canvas.

Set the operator to is on or after and choose Now again.

Combine these with AND, and you’ve got exactly:

start_date <= Now
AND
end_date >= Now

This Now option is part of AEP’s time-constraint features in the Segment Builder UI

 

Use PQL in Code View

If you prefer to work in code or need to manage this programmatically, switch to Code view in the Segment Builder and you’ll see (or can edit) the equivalent Profile Query Language and add definition. You can then push this definition through the Segmentation API’s /audiences endpoint

 

Reference:

https://experienceleague.adobe.com/en/docs/platform-learn/tutorials/audiences/time-constraints

https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/ui/segment-builder

Note: This response is inspired from Generative AI.

 

Thanks

Ankit

2 replies

AnkitJasani29
AnkitJasani29Accepted solution
Level 6
May 23, 2025

Hi @trojan_horse ,

Use the Now token in the UI

Drag your start_date attribute onto the canvas.

Set the operator to is on or before and, in the date picker, choose Now (this represents the current timestamp).

Drag your end_date attribute onto the canvas.

Set the operator to is on or after and choose Now again.

Combine these with AND, and you’ve got exactly:

start_date <= Now
AND
end_date >= Now

This Now option is part of AEP’s time-constraint features in the Segment Builder UI

 

Use PQL in Code View

If you prefer to work in code or need to manage this programmatically, switch to Code view in the Segment Builder and you’ll see (or can edit) the equivalent Profile Query Language and add definition. You can then push this definition through the Segmentation API’s /audiences endpoint

 

Reference:

https://experienceleague.adobe.com/en/docs/platform-learn/tutorials/audiences/time-constraints

https://experienceleague.adobe.com/en/docs/experience-platform/segmentation/ui/segment-builder

Note: This response is inspired from Generative AI.

 

Thanks

Ankit

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    June 30, 2025

    @trojan_horse Just checking in — were you able to resolve your issue?
    We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...