7 Replies Latest reply on Jun 29, 2009 4:07 PM by jamie.hunt

    Calculate average time left between a set of dates.

    jamie.hunt

      Title

      Calculate average time left between a set of dates.

      Post

      I hope someone can help me out. I'm not sure how easy this is or not.

       

       

      I am looking for a calculation to find the average number of days between a set of dates. For example if I have a set of dates such as:

       

      01/01/2009, 

      06/01/2009, 

      11/01/2009, 

      14/01/2009,

      17/01/2009.

       

      Time between the dates is

       

      5 days

      5 days

      3 days

      3 days

       

      So the average time between dates is 4 days.

       

       

       

       

      To put this into context this is so I can calculate the average time a Client leaves between their Appointments.

       

       

      I have a table with Client profiles set up which hold client contact information (such as Name, Phone, Address...)

       

      I have a table for client Appointments set up with appointment information (such as Date, Time, Name of client, The service they had...)

       

      They are linked by a field "clientID" and in a layout for Client Profiles there is a portal showing all previous Appointments for which ever Client.