does anybody know a way to calculate the age of a record.

I am writing a call logging system, and as each call is recieved a field in the calls table is used to store the date and time ( using the vb NOW function )

What the system does at a later point is queries the database and gets all outstanding calls.

I then grab the oldest call, and I need to be able to say how old the call is in DAYS, HOURS and Minutes.

But I am not sure how to do this, is there a vb funstion to carry out the calculation?

IE:

Outstanding = NOW - OLDDATE

ANY IDEAS!!!