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
Last activity: Mar 12, 2014, 03:57 PM