Date Filter

[bodhisatvaofboogie]

I have a list of parts, one column is the date they were added to a system.
The dates range from years and years ago to present.

I want to have my query subtract 12 months from the current date so that it
will automatically omit those parts that have date added that falls within
the last 12 months and do this for me without a prompt

<[Added after what date mm/dd/yyyy]

Currently if I put this line in my query, it will prompt me for the number,
so I have to type in 12 each time. What could I put in as a line to have it
just always subtract 12 months from the current date with no prompt? Thanks
in advance!!!

 

[Ken Snell \(MVP\)]

Try this as the Where criterion:
< DateAdd("m", -12, Date())

 

[bodhisatvaofboogie]

Worked great thanks for the help!!!

Try this as the Where criterion:
< DateAdd("m", -12, Date())

--

Ken Snell
<MS ACCESS MVP>

I have a list of parts, one column is the date they were added to a system.
The dates range from years and years ago to present.

I want to have my query subtract 12 months from the current date so that
it
will automatically omit those parts that have date added that falls within
the last 12 months and do this for me without a prompt

<[Added after what date mm/dd/yyyy]

Currently if I put this line in my query, it will prompt me for the
number,
so I have to type in 12 each time. What could I put in as a line to have
it
just always subtract 12 months from the current date with no prompt?
Thanks
in advance!!!