6 months ago

Huw CEIRIOG · Dec 21, 2003

How do I query a date field for dates less than 6 months ago?

Thanks

Van T. Dinh · Dec 21, 2003

SELECT *
FROM YourTable
WHERE [DateField] BETWEEN DateAdd("m", -6, Date()) AND Date()

Dan Artuso · Dec 21, 2003

Hi,
Use the DateSerial function.
6 months ago would be:
DateSerial(Year(Date()),Month(Date()) - 6,Day(Date()))