# Thread: Calculating Elapsed time betweek appointments

1. Registered User
Join Date
Dec 2003
Location
USA
Posts
21

## Unanswered: Calculating Elapsed time betweek appointments

I have a large database that contains many date fields. I need to run calculations for dates between two fields to determine elapsed time. I have tried the following with no luck:

Can anyone be more specific? It seems to be a simple matter of a calulation of time between the two fields.

Thank you
Lakota

2. Grand Poobah
Join Date
Sep 2003
Location
MI
Posts
3,713

## Re: Calculating Elapsed time betweek appointments

Originally posted by lakota2k
I have a large database that contains many date fields. I need to run calculations for dates between two fields to determine elapsed time. I have tried the following with no luck:

Can anyone be more specific? It seems to be a simple matter of a calulation of time between the two fields.

Thank you
Lakota
What is the size (or scope) of the elapsed time?

3. Registered User
Join Date
Dec 2003
Location
USA
Posts
21

## Re: Calculating Elapsed time betweek appointments

Originally posted by M Owen
What is the size (or scope) of the elapsed time?
M Owen:

Could be a matter of a few days or a few weeks. I would imagine that nothing would exceed more than a month.

Lakota

4. Registered User
Join Date
Dec 2003
Location
Dallas, TX
Posts
1,004

## Re: Calculating Elapsed time betweek appointments

lakota2k

I have done just the same thing in my databases. If you just need to get the total amount of days that have elapsed i.e. SetupDate: 2/5/04 ShippedDate: 2/8/04 ElapsedDays = 3 Then do this as I have done. Since you have both date fields already, have both in a query then create the expression like: ElapsedDays:[ShippedDate]-[SetupDate]
That will return you a plain number, the difference. Hope that helps.

5. Registered User
Join Date
Dec 2003
Location
USA
Posts
21

## Re: Calculating Elapsed time betweek appointments

Originally posted by Bud
lakota2k

I have done just the same thing in my databases. If you just need to get the total amount of days that have elapsed i.e. SetupDate: 2/5/04 ShippedDate: 2/8/04 ElapsedDays = 3 Then do this as I have done. Since you have both date fields already, have both in a query then create the expression like: ElapsedDays:[ShippedDate]-[SetupDate]
That will return you a plain number, the difference. Hope that helps.
This seemed to work, although I have been getting numbers displaying in negative conotations throught the query.