Re: Date Query
Thank you Arnel GP and CJ_London both for your help.
I have managed to get the code working for the dates within the last 2 years, however I am still having issues with the one that picks up only dates older than 2 years.
I have put the attachments for the SQL, Datasheet and design view, so you can see exactly what i am doing and the outcome.
You can see in the datasheet that it is still picking up items from 2017, 2018, 2019.
I would only like it to pick dates that are older than September 2017.
Once this date goes past 2 years, these are put into another section of my database so the person knows that are due for a review.
I hope this all makes sense.