sql report for last 12 months from the last date of previous month code example Example: sql where last 12 months select Dateadd(Month, -12, GETDATE())