How can I target profiles whose membership end date falls in the month exactly 3 months from now?

3 replies
49 views
Translate All

Hi all,

I have a field called Membership End Date, which always contains the last day of a month.

Examples:

31/08/2026
30/09/2026
31/10/2026
30/11/2026

I need an audience containing profiles whose membership end date falls in the month that is exactly three calendar months from today.

For example:

Today's date: 14/08/2026
Target month: November 2026
Expected audience: all profiles with a Membership End Date of 30/11/2026

Similarly:

If today were 05/09/2026, I'd want all profiles ending in December 2026
If today were 20/10/2026, I'd want all profiles ending in January 2027

What I've Tried

"In next 3 to 3 months"

This appears to return profiles with an end date of 31/10/2026 rather than 30/11/2026, which suggests it's calculating a rolling three-month period rather than the calendar month three months ahead.

90-120 day range

This works inconsistently because month lengths vary.

Rolling date ranges

I can see options for ranges such as "3 to 3 months ago", but I can't find an equivalent approach for future months.

Question

Is there a way within Audience Builder to target profiles whose date falls within the calendar month exactly three months from today's date, without creating additional calculated/boolean fields upstream?

Or is the recommended approach to derive this logic before the data reaches AEP?

Any suggestions would be greatly appreciated.

Thanks,
Will

WillGo3Author

Level 2

Just to add, I’ve also seen that you can in theory do this within an AJO journey, e.g. by simplifying the audience to members, then using an optimise node to pick the field and write a condition - however you can only pick string fields and not dates, so this does not work either.

Translate

R

RajeshMe6

Level 1

Hi @WillGo3

You can achieve this using a single audience by defining the first condition as birthDate occurs in the last 90 days and then adding an OR block with hard-coded values for the last day of each month while ignoring the year. This will return all profiles that match the date criteria. I've shared a snapshot using the next three month-end dates (Oct 31, Nov 30, and Dec 31) as an example, and you can continue adding upcoming month-end dates in the same manner.

Alternatively, you can build this using a Composed Audience, where the parent audience contains the birthDate occurs in the last 90 days condition and a subset audience contains the month-end birth date logic. However, the single audience approach is more straightforward and easier to maintain for this use case.

Thanks