Lots of ways to do this, you could make a query and use a date range criteria or make a field with DateDiff Function

Add this to the query criteria under the date field in the query
Not Between DateAdd("m",-11,Date()) And Date()

Then it will only show dates that are older then 11 months.

Thank you i will give this a try ;0)

Hi, i think maybe i didnt explain this correctly...Hopefully this will help with what I am trying to do. I have say 3 cylinders...as follows:
ACU123456, this cylinder was filled on 5 Jan 21, 5 May 21, 5 Jun 21 and 20 Jul 21
ACU987654, This cylinder was filled on 15 Jan 21, 5 May 21, 5 Jun 21 and 31 Jul 21
AGD123987, this cylinder was filled on 15 Jul 20, and has not been filled since. By code we are required to empty it and refill it within 12 months.
How do i identify these cylinders? we have 399 cylinders filled from 5 different locations. All the data and dates go into a central database on the server. so all the key information is available.

Hopefully i explained this better? I have tried a number of ways none resulted in any thing successful.

So what you're saying is you don't store a LastRefilledDate, you just store all the dates that you did a refill?

If so, you can use the same thing, we just need to use DMax to get the more recent date for that cylinder.

You would make a new expression on your query, like LastRefilledDate: DMAX("Date","Table","ID") and then we would put the criteria onto that field instead

Thank you.  Yes we have to track every fill that these cylinders have. We must have a full history of the 15year life span.

Kim just making sure.  For each cylinder you have the fill date in its own record I hope.  The ACUxxx being the serial number?