WARDY IT Solutions Blog

A blog on Brisbane's leading SQL Server consulting and training company

Last Monday’s Date

Often when reporting there is a need to determine what Monday's date was for the previous week. For example give me all sales from Monday to Sunday for last week. The following Reporting Services snippet will calculate what last Monday's date was:

DateAdd("d", -6,DateAdd("d", 1 - Weekday(Today), Today)

Published Wednesday, July 09, 2008 6:08 PM by peter@wardyit.com

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(optional)
(required) 
Submit