DateAdd

[nggman]

I need to use DateAdd to go back 1 month. I only want the result to be YYYYMM though. For example, today is 9/6/2018. I would want my result to be 201808. I have tried this but it does not work. Any help is appreciated. This is for an Access query. Thank you.


DateAdd("m", -1, "201809")

[June7]

Format(DateAdd("m", -1, Date()), "yyyymm")

[nggman]

Thank you!!!!!!!!!