Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    USA
    Posts
    21

    Red face 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:

    DateDiff("y",[Received Date],[HCP Selection Date])

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

    Please assist.

    Thank you
    Lakota

  2. #2
    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:

    DateDiff("y",[Received Date],[HCP Selection Date])

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

    Please assist.

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

  3. #3
    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. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking 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. #5
    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.

    Thank you for your help.
    Lakota

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •