Calculating dates/times

  • Thread starter Thread starter Shelby
  • Start date Start date
S

Shelby

Is there any way to make Access calculate the difference
between two dates and times in a query, so that I could
track the turnaround time on something?
 
Shelby said:
Is there any way to make Access calculate the difference
between two dates and times in a query, so that I could
track the turnaround time on something?
Click to expand...

Check help for the DateDiff() function. It will return the number of "intervals"
between two date time values. You can choose what the interval is.

If you want something like 2 Years, 7 Months, 12 Days, 17 Hours and 15 Minutes. Then
you would have to create a custom function.
 
Back
Top