Create a filter and comparing two dates
Hi all,
I'm trying to create a filter using the Filter Designer to identify an audience where their Purchase Date (PURCHASE_DATE) is more recent than their Product Registration Date (PROD_REG_DATE).
PROD_REG_DATE is in the CONTACTS_LIST and PURCHASE_DATE is in a PET table (PET3).
Is there a way to compare two date fields?
Thanks,
Tony
0