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]

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!