Filter 6 months with end date of the end of the last full month

[ali32uk]

Hi

I m using the following as criteria in my query

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

which works great but does nt quite do what i m looking for. this takes from the current date, ideally what i want is from the last full month, i.e. today is 28th July, so it filters both of the above from the end of last month 30th June

If any one can help it would be much appreciated

BR

Ali

 

[dhookom]

To get the last day of the previous month, replace Date() with Date()-Day(Date())


Duane
Hook'D on Access
MS Access MVP