How to Find the Start and End Dates for the Current Week (and more)

Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)

Implementing Date Calculations in SQL

This article explains a way to use labels (last year, YTD, etc.) for report parameters.

Moving to a time zone offset

New Year's Math