I have a SSIS package that pulls data by SQL query and creates an Excel spreadsheet. However I'm having trouble formatting the date range it pulls by. It's going to run every monday and I need to it to pull the date range for the previous week. I've found how to do DateAdd but I'm not sure how to use it in conjunction with the current date.

Any help would be great! Thanks.