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).
