dates back 6 months

[krberube]

Good morning all,
I currently have the following expression in a query, to go back 6 months from the current date.

Between DateAdd("m",-6,Date()) And Date()

Does anyone know of a way from the current date, go back to the end of the previous month ( 30th, or 31st) then go back 6 months?

hope that made sense.
Thanks
Kevin

 

[KenHigg]

I'd just have the user enter the date range -

 

[krberube]

ahh, thats how the report ( query) started, it has sinced morphed into a more complicated and useful report.
I found a post ( right after i posted the thread) that gave

>=DateSerial(Year(DateAdd("m",-6,Date())),Month(DateAdd("m",-6,Date())),1)

This seems to have worked
Thanks