DateDiff

[Jay]

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.

[Raymond]

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.