Date minus 1 year

[jbphoenix]

I am creating a report and I need data about parts that have not been used in the past 12 months. I'm not sure how to get just numbers from the past 12 months. How do I get the current date minus 1 year?

 

[Banana]

I don't have Access help with me, so this is totally off the top of head. Look into help about DateDiff function, and see if there's also a Year function.

HTH.

 

[boblarson]

How do I get the current date minus 1 year?

If used in code:
YourDateField = DateAdd("yyyy", -1, Date)

If used in a query or controlsource:

DateAdd("yyyy", -1, Date())