Finding Difference between two dates

K

Kostas Tsolis

You may want to use The DateDiff function. Type in the
expression:
FieldName: DaysPassed: DateDiff("d", date1, date2)
Then you can set criteria: >30 for that field.
Hope that helps
Kostas
 
J

Judy Andrews

Using the step below, I still get the message box asking
for a paramenter for date1, and date2. Am I missing
something? Example: A person could have three records
and I am looking for the days between the 1st and 2nd
visit and the days between the 2nd and 3rd visit, etc.
Thanks for your patience!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No.f days between dates, no w/e and Fridays 2
calculate months between two dates 3
Lapsed Time when 1 date is null 2
Trouble with VBA loop 5
DateDiff function throwing error in Where clause 6
how do i not count weekend days in an access querry 0
If/Then/Else Query 6
CalcWorkDays error 2

Top