parameter date minus four years

[mitchem1]

I have a report that will prompt the user to enter a Purge Date. The query behind the report should then retrieve all records from the Purge Date backward four years. I have been working with a function like DateAdd("yyyy", -4, [PurgeDate) but have been unsuccessful so far. I am not sure how to enter something in the query criteria such as [Please enter the Purge Date] and then get it to work with the function.
Thanks in advance for any ideas.

After re-reading my post, I think maybe this will explain it a little better. If I insert Between [Enter Beginning Purge Date] And [Enter Ending Purge Date] in the query Criteria, I return the correct records. I am attempting to do something similar, but 4 years backward from the date the user enters. Thanks.

 

[Rich]

>=DateAdd("yyyy", -4, [Please Enter PurgeDate])