Sample Header Ad - 728x90

SSIS: Get Date for Day of the Week

1 vote
1 answer
5714 views
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())
Asked by PeterX (177 rep)
Feb 7, 2014, 05:57 AM
Last activity: Mar 12, 2014, 03:57 PM