asp time diff 1

[hz]

I know there is a datediff() function to calculate the time different between different days. Is there a way to calculate the time difference between the same date?

 

[JohnYingling]

Same function. If all you have is a time then fake a data with DatSerial(1900,1,1) for both times.

http://WWW.VBCompare.Com

 

[JohnYingling]

Use "h", "n" (yes n) or "s" (lower case) as the interval.

http://WWW.VBCompare.Com

 

[hz]

Thanks for the reply, I am not too sure about what you mean, could you plz give a code example?

 

[hblackorby]

DateDiff can calculate between times as well. The function name can be confusing, but it is referring to Date objects (which include times) just not dates.

Anyway, you can do this:

DateDiff(interval,date1,date2)

Intervals can be any of the following:

Setting Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week of year
h Hour
n Minute
s Second

To calculate times, date1 and date2 need to be VB/VBScript date variable types.

Hope this clarifies for you. Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[Ovatvvon]

DateDiff doesn't work for me...
error:

---------------------------------------------
Microsoft VBScript runtime error '800a0005'

Invalid procedure call or argument: 'DateDiff'

/date.asp, line 6
---------------------------------------------

Here is a sample of what I typed, maybe you can tell me what I'm doing wrong.

<%
Dim date1, date2, differs
date1 = &quot;6/17/1988&quot;
date2 = &quot;9/14/1997&quot;

differs = DateDiff(yyyy,date1,date2)

response.write differs
%>


Thx,
-Ovatvvon

 

[mdclarke]

Hi,

Have a look at the syntax here

http://msdn.microsoft.com/scripting/default.htm

- VBScript
- Documentation
- Language Reference
- Alphabetic Keyword List


M. Clarke