Hi,

How to use target_lookup or check a field in a target table to find out if date is less than 10 days before processing deletion? The rows are currently getting deleted even after adding the below expression.

when $AR_H_OPERATION = 'DELETE' AND (***below is a target table field***)
date($DATE, '+5 day') < date('now')then only delete


Thanks,
student