I have just looked at the Access help features:
Returns a number that represents today's date. When TODAY is entered in a cell, it is automatically formatted as a date. TODAY changes whenever the sheet changes.
Returns the serial number that represents the date that is the indicated number of months before or after a specified date.
If this function returns the #NAME? error value, you may need to install msowcf.dll.
Start_date is a date from which to count forward or back a given number of months. The number of months is determined by Months.
Months is the number of months before or after Start_date, which is positive for a future date and negative for a past date.
So, on this basis, try running a query: