Subtracting 2 dates to find a number of days inbetween

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

Fredg

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

Or..

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

Dave

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!


.
 

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

Top