System Date for Access 2000

[Marita_l]

I have a query where I want to pull only those records where The field for
QuoteDate <=( Todays Date - 12 months).

I have located Edate but Access 2000 seems to have a problem with this.

In ORACLE I would just perform a calculation on SYSDATE - "12 months from
now") ,not exact code, and be done with it. Is there something similair in
Access 2000? or why want it work.

Thanks in Advance,

Marita

[Clunietp]

use the DateAdd Function

SELECT dateadd("m", -12, Date()) as TheDate