Here is one way to do this:
Dim fDate, d, h, m
fDate = CDate("2004-08-28")
m = DateDiff("n",now(),fDate)
h = m\60
d = h\24
m = m - (60*h)
h = h - (24*d)
Response.Write(d&" days "&h& " hours "&m&" minutes")
Response.End()
--
Raymond Yap
"Jay" <jl****@optonline.net> wrote in message
news:fs********************@news4.srv.hcvlny.cv.ne t...
I am trying to replicate the Ebay Time Left on Auction.
1 Day, 1 hour, 12 minutes.
I would like to calculate this from the current time and date. How do I
get this result?
Thanks for the help.