I have a text file and created a model to capture the data but only want to pull in the last 7 days based on transaction date. I have tried various things (filters, calculated formulas, etc) in Monarch Classic and Data Prep but unable to capture all of the dates. For example, today is 05/30/24 and want data from 05/22/24 thru 05/29/24. Thanks