Drop Records based on a date in a Field

Hi,

How might I discard records that have a field called "rundate" where the rundate is more that 7 days of the current date?

Thanks!

Hello

Calculate the difference between rundate and current date using the datediff function.
www.etl-tools.com/wiki/aetle/transformat...tions/date/date_diff
to get current date use "Current date" transformation function
www.etl-tools.com/wiki/aetle/transformat...ns/date/current_date
Then use "Is number more than" to discard the records
www.etl-tools.com/wiki/aetle/validation_rules/numbers