EIM - DELETE MATCHES Older Than x - 2 yrs
Is there a way to do an EIM DELETE MATCHES were the the CREATED date is older than 3 years? I know I could put a static date here but I want it to be derived every time I run this.
[Campaign Members Purge]
TYPE = DELETE
TABLE = EIM_CAMP_CON
BATCH = 201401
DELETE MATCHES = S_CAMP_CON, (CREATED < {date 2 years ago})
LOG TRANSACTIONS = FALSE
ONLY BASE TABLES = S_CAMP_CON
I'm also aware of the $CURRENT_DATETIME however, I need a date that's 2 years ago.
DELETE MATCHES = S_CAMP_CON, (CREATED < '$CURRENT_DATETIME')