I am trying to create an entry event for Contacts when the transaction date has been > 120 days or = equal to 120 days in the past.
Contacts are synced in a synchronized DE The transaction date is stored in TransactionHeader as synchronized DE from SF. Contact.Id is subscriber key and Contact.Id is related to TransactionHeader.BilltoContact.
Transaction date is stored in the following format: 06 March 2018 13:00
I have create a data based event for this:
Data Extension Name: TransactionHeader Contact Attributes: TransactionHeader.TransactionDate Re-entry: Yearly Date: 120 days after TransactionHeader.TransactionDate Time: 12:00 AM Time Zone (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London
Contacts are not entering the journey and I ran out of options to think of. Is this even possible to achieve or should I create a daily query as entry event?