We have answer of your question!

100% solved queries, no empty question

Question: Access query SQL difference in dates


0

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.

Question author User2002716 | Source

Answer


1


Try....

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.

Related Search Queries:


You may also add your answer

Thanks for contributing an answer to Tick Answer!