Calculating time in days

[Kahanae]

Hi,

Please help! I have a very simple database for a client list. We currently
have a column for the date of referral, a column for the date of initial
assessment, a column for the date of first visit, and a column for the date
of discharge. We want to be able to calculate the length of time between
these dates. For example, "Length of stay" would be the number of days
between assessment and discharge, "Wait Time" would be the number of days
between referral and assessment etc.. Could someone let me know how to do
this? I'm very new to Access, so I would need very detailed instructions


Thank-you all SO much!

 

[Golfinray]

To do standard date length calculations do Datediff, example:
Datediff("d",[firstfield],[secondfield]) will give you the days between the
forst column and second column. the "d" is for days. You can also do minutes,
months, years, etc.

 

[Daniel Pineault]

For this type of calculation you will need to become familiar with the
DateAdd and DateDiff functions.

Specifically use the DateDiff("d",Date1,Date2)

where "d" is telling the function to return the difference in number of day.
You could specify months, years....

Look at the help file, it is well explained with examples.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.