To get the first date of the week by passing the week id
dateadd(wk, datediff(wk, 0, getdate()), 0)
To get the last date of the week by passing the week id
dateadd(wk, datediff(wk, 0, getdate()), 0) + 6
dateadd(wk, datediff(wk, 0, getdate()), 0)
To get the last date of the week by passing the week id
dateadd(wk, datediff(wk, 0, getdate()), 0) + 6
No comments:
Post a Comment
Please include your thoughts/suggestion to make it as a better blog. If you find it useful, Please update with your valuable comments, so that others can use it.