Solve a SQL statement

tackey

I calculated the data of the previous month this month, and I want to get the month automatically as MONTH (DATE) -1, but if I encounter January, it will be difficult to handle. How can I write such a SQL statement? Or is there any other way to solve it?

彻底复仇

Subtract 30 days from the current date, then take the month

restajufehyg

d = Month (DateAdd ("m", -1, Date))

tackey

But how does the year differ, please be specific, thank you!

likepaopao

IntMonth = IIf (Month (Date) = 1, 12, Month (Date)-1)
IntYear = IIf (IntMonth> Month (Date), Year (Date)-1, Year (Date))

likepaopao

I read it wrong and asked SQL statement. Khan ~~~

restajufehyg

If the format containing the year and month is yyyy-mm then:

The SQL database can:
convert (varchar (7), dateadd (month, -1, getdate ()), 120)

access can:
Format (DateAdd ("m", -1, Date), "yyyy-mm")