Displaying data from the past six months

J

joshroberts

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"))
Click to expand...

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?
 
K

Klatuu

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

joshroberts said:
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?
Click to expand...
 
Top