Get previous month and year with SQL mssql AND YEAR(t.shr_date) = YEAR(DATEADD(year,-1,getdate())) AND MONTH(t.shr_date) = MONTH(dateadd(month, datediff(month, 0, getdate())-1, 0))

https://www.myridia.com/questions

# get the previous month in the 112 format ```sql AND l.[date] = CONVERT(VARCHAR(10),dateadd(month, datediff(month, 0, getdate())-1, 0),112) ``` 02.01.23

https://stackoverflow.com/questions/1424999/get-the-records-of-last-month-in-sql-server

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2026