How do I calculate how old a date is or convert a date into a number?

This can be done by creating a view and using the DATEDIFF function. Here is a DATEDIFF code sample that will calculate the numerical difference between two dates.

SELECT DATEDIFF(day,OrderDate, GETDATE()) AS DaysOld FROM Orders

Created Saturday, May 24, 2008 by david.hu@izenda.com
http://www.izenda.com/Site/KB/FAQ/How-do-I-calculate-how-old-a-date-is-or-convert-a-date-into-a-number