Date variable for access query

[nggman]

I can use this: Format(DateAdd("m",-1,Date()),"yyyymmdd") in the criteria of my MS Access query and it will subtract one month for me and work. If I use this: Format(DateAdd("m",-1,"StartOfMonth"),"yyyymmdd") to try to get the FIRST of the previous month I get a 'Data type mismatch in criteria expression' error. Does anyone know a fix for that?



Thank you.

[nggman]

I found this and it worked!!

Format(DateSerial(Year(Date()), Month(Date())-1,1),"yyyymmdd")