Purging 7 yrs old data from Access

[pullaiah.cts]

Hi all,



This is my first post in this forum.

I have requirement that I need to purge the records from all the tables that are older than 7 years.I have identified the fileds based on which I can delete the data but the problem is how to write the query to fetch the data that is older than 7 Years.

This is my query:
Select * from Case where StatusDate < DateValue('01/01/2005')

But I want to get the date based on current date.For example,If I want to delete the data that is exactly older than 7 years from current date i.e. data older than sep 27th,2005.

Is there any way to get the data that is exactly older than 7 years.

Thanks in advance.

[pbaldy]

Check out the DateAdd() function (and the Date() function):

Select * from Case where StatusDate < DateAdd(...)

with the appropriate arguments inserted.

[pullaiah.cts]

Hi Paul,

I have tried the query with DateAdd function and it perfectly suits my requirement.

select count(*) from Case where OpenedDate <= DateAdd ('yyyy', -7, now())

Thank you so much for your help!!!

[pbaldy]

Happy to help. Welcome to the site by the way!