I am in the process of putting a countdown timer in my online auction. Right now, I'm using the DateDiff function to figure the Hours, Minutes, and Seconds remaining in the auction. The 2 problems I'm facing are: (1)How do I format the minues and seconds to represent 'real' minutes and seconds, not the total minutes and seconds; and (2)Where is the best place to format the number to whole numbers instead of having decimals?
The script I created is here:
DiffHrs = DateDiff("h", Now, rsBid("LastBidTime")
DiffMin = DateDiff("n", Now, rsBid("LastBidTime")
Diffsec = DateDiff("s", Now, rsBid("LastBidTime")
Response.Write _
"<TD><FONT SIZE=""-1"">" & rsBid("MaxBidAmount" & "</TD>" & _
"<TD><FONT SIZE=""-1"">" & rsBid("LastBidTime" & "</TD>" & _
"<TD><FONT SIZE=""-1"">" & DiffHrs & ":" & DiffMin & ":" & Diffsec & "</TD>"
Also, if there's an earier way to do this, I'm open to suggestions.
The script I created is here:
DiffHrs = DateDiff("h", Now, rsBid("LastBidTime")
DiffMin = DateDiff("n", Now, rsBid("LastBidTime")
Diffsec = DateDiff("s", Now, rsBid("LastBidTime")
Response.Write _
"<TD><FONT SIZE=""-1"">" & rsBid("MaxBidAmount" & "</TD>" & _
"<TD><FONT SIZE=""-1"">" & rsBid("LastBidTime" & "</TD>" & _
"<TD><FONT SIZE=""-1"">" & DiffHrs & ":" & DiffMin & ":" & Diffsec & "</TD>"
Also, if there's an earier way to do this, I'm open to suggestions.