I have a table that has a field "Order Date" which is based on the date of entry to the database. The "Follow up Date" is then calculated 1 year on from this in the table.
In the query I want to find all records that have this DD/MM from all previous years
Currently the criteria of the query reads:
Follow up date :
Date()
Date()-365
Date()-731
Date()-1097
Date()-1463
This does not work for every year due to leap years and such.
I would like a simple query criteria that returns all records with the DD/MM of "follow up date" equal to today's date
Kind Regards
Joe