How do you add time to a Delete query? 1

[quest4]

Good afternoon, folks. I have a WHERE statement which I need to modify to say anything three years old today. Here is my statement:
WHERE (((tblECN_MasterData.DateEnd)<=Date())) OR (((tblECN_MasterData.DateCancelled)<=Date()));
Thank you to anyone answering this question.

 

[swaybright]

Subtract three years worth of days (less one) from the current date.

WHERE (((tblECN_MasterData.DateEnd)<=Date()-1094)) OR (((tblECN_MasterData.DateCancelled)<=Date()-1094));

Unfortunately this will not take into account any leapyears the may or may not have occured during the past 3 years.

Shane

 

[quest4]

Thank you for the assistance, Shane. Works great.