Thread: Date Query
View Single Post
Old 09-24-2019, 05:28 PM   #11
Aimn_4U
Newly Registered User
 
Join Date: May 2019
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Aimn_4U is on a distinguished road
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.

Thank you
Attached Images
File Type: jpg More than 2 years old - datasheet View.jpg (98.1 KB, 15 views)
File Type: png More than 2 years old - Design View.PNG (34.8 KB, 11 views)
File Type: png More than 2 years old - SQL view.PNG (26.3 KB, 11 views)
Aimn_4U is offline   Reply With Quote