Request Help Understanding Audience Segment Date Criteria | Community
Skip to main content
May 6, 2025
Solved

Request Help Understanding Audience Segment Date Criteria

  • May 6, 2025
  • 2 replies
  • 400 views

I am attempting to create an audience where an activity occurred within the last 5 years. It seems that the criteria I expect to work is generating code that performs the opposite. For example, event rule:

 

Boat_Activity_Date "In Last" 5 Years

 

Generates this code snippet:

 

WHERE(C0.exists(_xxxxxxxx.Boattransformed_BoatDemographic.Boat_Activity_Date occurs <= 5 years before now))])

 

Reading the WHERE condition, it seems to specify records where the Boat_Activity_Date is older than 5 years before now. Should it not have "occurs >= 5 years before now".

Best answer by supratim320

Hi @dhickman13 

I was thoroughly confused as well and looked at my own environment and played around it before answering you 🙂

  • Boat_Activity_Date "In Last" 5 Years" typically translates to: Boat_Activity_Date falls within "Last 5 years" from today, i.e. falls within 07/05/2020 (DD-MM-YYYY). So the condition goes for: "occurs <=  5 years before now"
  • If you are looking for: "occurs >= 5 years before now", then that will mean: "Boat_Activity_Date earlier than years"

Hope this resolves!

2 replies

supratim320Accepted solution
Level 5
May 7, 2025

Hi @dhickman13 

I was thoroughly confused as well and looked at my own environment and played around it before answering you 🙂

  • Boat_Activity_Date "In Last" 5 Years" typically translates to: Boat_Activity_Date falls within "Last 5 years" from today, i.e. falls within 07/05/2020 (DD-MM-YYYY). So the condition goes for: "occurs <=  5 years before now"
  • If you are looking for: "occurs >= 5 years before now", then that will mean: "Boat_Activity_Date earlier than years"

Hope this resolves!

Supriya_Savre
Level 4
May 14, 2025

Hi @dhickman13,

I hope the response shared above helped address your question. If it did, it would be wonderful if you could mark it as "correct reply"— this helps others in the community find helpful solutions more easily.

If you’re still facing any challenges, please feel free to continue the conversation here. We’re happy to support further.