Get previous months date in year and month format

Question

What function can I use to get the previous months date in the format yyyy-mm . This is what I have tried.

SELECT FORMAT (getdate(), 'yyyy-MM') as date

Answer 1

You could use DATEADD:

SELECT FORMAT (DATEADD(mm, -1, getdate()), 'yyyy-MM') as date

db<>fiddle demo