Specific steps to determine # of days ( today's date and other dat

  • Thread starter Thread starter Stefanie
  • Start date Start date
S

Stefanie

I am in need of specific steps (yes, I am new and still learning!) of how to
determine the number of dates between "today's date" and another specified
date.

It is to prepare a report showing any cases that have been filed longer than
100 days.

thank you!!
 
Stefanie said:
I am in need of specific steps (yes, I am new and still learning!) of how to
determine the number of dates between "today's date" and another specified
date.

It is to prepare a report showing any cases that have been filed longer than
100 days.
Click to expand...


Use the DateDiff function:
DateDiff("d", [another date], Date())

Where you use that and what else may be needed depends on
what you are trying to accomplish. Your question kind of
implies that you want it in a query, but more likely it
should be in a form's command button's Click event procedure
code used to open the report.
 
Back
Top