date & time difference calculation

[RSheehan@ci.bellevue.wa.us]

The best method for turning days into years, months, and days is just to
be patient!

:-)

Sorry, but I couldn't resist!

It was time to re-introduce some light heartedness into the list.

Richard S Sheehan
425.452.6177
Business Systems Analyst 
City of Bellevue, WA



-----Original Message-----
From: Lorry Litman [mailto:LLitman@exchange.hsc.mb.ca] 
Sent: Tuesday, May 18, 2004 5:48 AM
To: 'Chris Sharman'
Cc: powerh-l@lists.sowder.com
Subject: RE: date & time difference calculation


Thank-you Chris, I'll give it a try.

How do I turn the days into years, months, & days?

As an example
 difference between 30-dec-2004-10:06 and 11-oct-2003-10:30
 results in 4452336 (445 days, 23 hours, 36 minutes)
 I need the result as 0102192336 (1 year, 2 months, 19 days, 23 hours,
36
minutes)

Any suggestions?
Maybe there are different powerhouse functions I can/should use.

Thanx
    Lorry

-----Original Message-----

This e-mail and/or any documents in this transmission is intended for
the address(s) only and may contain legally privileged or confidential
information. Any unauthorized use, disclosure, distribution, copying or
dissemination is strictly prohibited. If you receive this transmission
in error, please notify the sender immediately and return the original.