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

[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!!

 

[Marshall Barton]

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.

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.