Ive searched for awhile and I have tried numerous calculations I've found but none seem to work.
In a query I'm trying to limit it to the results where (Positionsfilled.HSRT_duedate) is more than 365 when factoring today's.
HSRT_duedate is formatted to show dd-mm-yyyy
So if the due date is 12-05-2016 and today's date is 13-05-2016 then it'll show everyone that has a due date of 12-05-2016 or before.
SELECT Positionsfilled.HSRT_duedate FROM Positionsfilled WHERE ((DateDiff("d",[HSRT_duedate],Date())>365));
Answer author Wayne-g-dunn
Tickanswer.com is providing the only single recommended solution of the question Access query SQL difference in dates under the categories i.e ms-access , ms-access-2010 , . Our team of experts filter the best solution for you.