DateDiff function in Access?

[jimmajsterski]

In Access SQL, is there a DateDiff function or some other built in mechanism for finding how many days between two dates?

As in: I want to examine the date field of "visit" records of food bank clients to see if their visits are too close together.

Maybe I need to do this in a Procedure. Anyone have
one they'd share? Thanks.

 

[lingsn]

Yes, there is DateDiff function that you can use in access query. Please refer to this url to read on the information

http://www.techonthenet.com/access/functions/date/datediff.php

A simple example to compare the date in the query would be

SELECT * FROM GLPOST
WHERE DATEDIFF('d', Crt_Dt, NOW) > 3

 

[jimmajsterski]

Thanks, lingsn. As it turns out, the user needed data by calendar month, not a "rolling" 30 day period, as I first thought. And after your reply, I did find the function in help. Thanks again.