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.
 

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

Steps to determine # of days between dates 4
Excel Message box with days of month & date. 1
Excel How to get the number of days an item was opened from the today's date. 14
Excel Formula - Count Dates from another Sheet 8
display number of records on form from date range 0
Counting business day from one date 2
Pull the Day of Week out of a Date 2
Count specific days in between dates 2

Back
Top