[Custom Objects] How to target COs by a datetime field

[Anonymous]

Hi there,

I have a Custom Object that has a number of fields, one of them being eventDate which... of course is the date of a given event specific to each instance of this Custom Object.

In the Smart Campaign Smart List, I would like to be able to target by batch each day the leads who have a Custom Object whose eventDate is 7 days back to be able to send a campaign 7 days after the event took place.

So for instance today being October 30, I would like my Smart List to list leads who have a Custom Object with eventDate between October 23 0:00:00 and October 23 23:59:59

The problem is there is no operator "is 7 days ago" in the "Has Custom Object" block:

Until now I have been using the "Was added to Custom Object" block instead with 2 constraints to make this work but it's very clunky:

- eventDate in past before 7 days

- Date of Activity in past 7 days (this is actually the date when the Custom Object instance is created, so I should not depend on this because some times our API import script doesn't work and needs to be run the next day which ruins everything)

I would rather only use the "Has Custom Object" block and only my custom eventDate datetime value if possible.

Does anyone know how to manage this?

Many thanks,

Thomas

P.S. I tried using 2 blocks "Has Custom Object" with "eventDate in past 7 days" in the first and "eventDate in past before 7 days"in the second and this doesn't work because it pulls all leads that have either condition although I use AND between both blocks. I ended up with leads that had COs for October 15 (2nd block) and October 27 (1st block)