In SSIS, how do I get the date for a specific day of the week? For example, how do I get last Sunday's date?
I assume I have to do some subtraction on the day-of-week, but not sure:
DATEADD("d", -DATEPART("DW", GETDATE()), GETDATE())
You can use the following code to get the date for any given day in the current week: