Solved

# diff between time and date?

Posted on 2001-07-17
270 Views
Can i find the difference between two time variables generated by now(). What is the easiest way to do that?
0
Question by:rav_chow
• 6
• 4
• 3
• +2

LVL 1

Expert Comment

ID: 6290633
Use DateDiff() function:

Description:
Returns the number of intervals between two dates.
Syntax:
DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear]])

Erez Sh.
0

LVL 1

Expert Comment

ID: 6290649
interval:
Required. String expression that is the interval you want to use to calculate the differences between date1 and date2.

date1, date2: Required. Date expressions. Two dates you want to use in the calculation.

firstdayofweek: Optional. Constant that specifies the day of the week. If not specified, Sunday is assumed. See Settings section for values.

firstweekofyear: Optional. Constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs. See Settings section for values.

The interval argument can have the following values:
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

0

LVL 5

Expert Comment

ID: 6290654
i agree with erezsh.

Interval = the time interval to find (month, week, second, etc)

date1= a date (your first Now )
date2= another date (your second Now )

and the other two values are optional and shouldn't be changed unless you need to know specific day/year stuff.
0

Author Comment

ID: 6290694
friends, I asked for time.. ie. hour ,min ..
0

Expert Comment

ID: 6290772
You asked for date and time and erezsh kindly gave you both.
0

LVL 18

Expert Comment

ID: 6290797
Now

The Now function returns the date and time as determined by your computer.

Code:
<% =Now %>

Output:
07/17/2001 10:36:12

If you want to get the diff on time, you will need to create seperate functions to retrieve each value;

dh = DateDiff(h, Now(), (Now()-4))

Response.Write dh
0

Author Comment

ID: 6290882
Microsoft VBScript runtime error '800a0005'

Invalid procedure call or argument: 'DateDiff'

this is the error is get when i try datediff
0

LVL 1

Accepted Solution

erezsh earned 100 total points
ID: 6290883
To get the differeces between two dates (and times) in minutes, for example, use:
MinDiff = DateDiff("n", date1, date2)

btw 10x for the support ;)
Erez Sh.

0

LVL 18

Expert Comment

ID: 6290894
Maybe you should go to the DevGuru web site and read up on the function DateDiff().
0

Author Comment

ID: 6290897
Microsoft VBScript runtime error '800a0005'

Invalid procedure call or argument: 'DateDiff'

this is the error is get when i try datediff
0

LVL 1

Expert Comment

ID: 6290921
Give me the entire code that you are using so I can tell you what's wrong.
0

LVL 1

Expert Comment

ID: 6290941
Here is a full code that tell you how long ago was the 24/6/2001 in says:

<HTML>
<BODY>
<%
date1= now
date2= #24/6/2001#
DayDiff = DateDiff("d",date1,date2)
response.write DayDiff
%>
</BODY>
</HTML>

It works. If it doesn't work for you, then your server has a problem.

Erez Sh.
0

LVL 18

Expert Comment

ID: 6290942
You do have IIS installed don't you?
0

LVL 1

Expert Comment

ID: 6290951
(in days)
0

LVL 18

Expert Comment

ID: 6290966
This tells you exactly in hours, the difference betweeen Now annd 4 days ago;

<%
dh = DateDiff("h", Now(), (Now()-4))

Response.Write dh
%>
0

## Featured Post

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was writtenâ€¦
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interactâ€¦
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the fileâ€¦
This tutorial demonstrates a quick way of adding group price to multiple Magento products.