Date problem

[Xenix]

I have the formula:

Format(DateAdd('m',-6,Now()),"mm/yy")

in my query but I want it to show six months back to now but it only shows the month from current -6 months how can I get it to show the other five months in between?


Kind regards

Mike

 

[Mile-O]

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


or


>= DateAdd("m", -6, Date())