Finding Difference between two dates

  • Thread starter Thread starter Kostas Tsolis
  • Start date Start date
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
 
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!!
 
Back
Top