Displaying data from the past six months

[Guest]

I would like to set up my query to automatically display data from the past
six months. My criteria row looks like this:

(Format(Date(),"yyyymmdd"))

yyyymmdd is the date format for the table. I realize this gives me todays
date but I want to know how to get it to automatically give me 6 months ago
(20060301). Can you help me out?

 

[Guest]

Format(DateAdd("m",-6,Date()),"yyyymmdd")

I would like to set up my query to automatically display data from the past
six months. My criteria row looks like this:


yyyymmdd is the date format for the table. I realize this gives me todays
date but I want to know how to get it to automatically give me 6 months ago
(20060301). Can you help me out?