Become a Premium Member and unlock a new, free course in leading technologies each month.
Go Premium for a chance to win a PS4. Enter to Win
SELECT DATEPART(dw, GETDATE())
Open in new window
Declare @dt date = '10-25-13'
SELECT DATEADD(d, - (DATEPART(dw, @dt) + 2), @dt) as last_thursday,
DATEADD(d, - (DATEPART(dw, @dt) - 2), @dt) as this_monday
DECLARE @myTuesdayDate date, @myMondayDate date;
SELECT @myTuesdayDate = DATEADD(DAY, DATEDIFF(DAY, 2, GETDATE()) / 7 * 7, 1);
SELECT @myMondayDate = DATEADD(day, 6, @myTuesdayDate)
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!