Request Help Understanding Audience Segment Date Criteria

[dhickman13]

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

[supratim320 · Accepted solution]

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]

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.