Subtracting 2 dates to find a number of days inbetween

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

access 97

In my query, I have a field for date of call, and
resolution date. I would like to somehow create a field
that shows the amount of time, in days, it took to solve
the issue...meaning, I would like to subtract reso date
from original date.

Example:

Date of call=10/6/03
Resolution date=10/8/03
Resolution Timeframe=2 days

Thanks!
 
Take your pick:
= [Resolution date] - [Date of call]

Or..

=DateDiff("d",[Resolution date],[Date of Call])
 
Thanks for the reply!!

Unfortunately, when I put in any sort of criteria in the
query, it gives me no results. I may have 7 or 8 entries,
if I put no criteria in issue resolved date, then it shoes
the 7 or 8 entries. As soon as I put a criteria, then it
shows nothing.

Here is a breakdown of exactly what I have

TT Number
Date of Call
Issue Resolved Date
Resolution Timeframe for Trouble Tickets

Those are the 4 fields in the query, when I put a criteria
in the Resolution Timeframe for Trouble Tickets field, I
get no results.

I did, of course, change the names :)

Also, this is pulling the data from the table Issues if
that means anything.

Thanks!
-----Original Message-----
Take your pick:
= [Resolution date] - [Date of call]

Or..

=DateDiff("d",[Resolution date],[Date of Call])
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Dave said:
access 97

In my query, I have a field for date of call, and
resolution date. I would like to somehow create a field
that shows the amount of time, in days, it took to solve
the issue...meaning, I would like to subtract reso date
from original date.

Example:

Date of call=10/6/03
Resolution date=10/8/03
Resolution Timeframe=2 days

Thanks!
Click to expand...


.
Click to expand...
 
Back
Top