date query

[mbparks]

I need to select all records where the date is more than 3 years old. I've
tried "<5/1/06" and "Before 5/1/06" and neither seemed to work.
Please help. Thank you.

 

[Piet Linden]

I need to select all records where the date is more than 3 years old.  I've
tried "<5/1/06" and "Before 5/1/06" and neither seemed to work.
Please help.  Thank you.

SELECT *
FROM MyTable
WHERE [DateField]<#5/1/06#

 

[mbparks]

Perfect. Thank you both so much.

If this calculation is going to be repeated at different times,
you may want to use a statement that doesn't involve
inputting an actual date, e.g.:

WHERE [DateField] < DateAdd("m", -36, date())

Lookup the DateAdd() function in the Help File for a
detailed explanation.

Bob

I need to select all records where the date is more than 3 years old. I've
tried "<5/1/06" and "Before 5/1/06" and neither seemed to work.
Please help. Thank you.

SELECT *
FROM MyTable
WHERE [DateField]<#5/1/06#