OK, I think this is quite clear: return the total number of days that passed, for instance, between the two date-times. The example I gave you earlier can easily be adapted to give the total number of elapsed centuries, years, months, days, hours, minutes or seconds. Just change the final value (1e6) to another power of 100.

Some additional calculations are required for the total number of weeks.

Hilmar.

>mm/dd/yyyy hh:mm:ss - Standard DateTime value
>08/27/2002 10:30:00 - Example
>
>From the SQL Server Books on Line
>
>

>DATEDIFF
>Returns the number of date and time boundaries crossed between two specified dates.

Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)