Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

diff between time and date?

Posted on 2001-07-17
15
Medium Priority
?
299 Views
Last Modified: 2008-03-17
Can i find the difference between two time variables generated by now(). What is the easiest way to do that?
0
Comment
Question by:rav_chow
  • 6
  • 4
  • 3
  • +2
15 Comments
 
LVL 1

Expert Comment

by:erezsh
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

by:erezsh
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

by:dredge
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

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

Expert Comment

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

Expert Comment

by:mgfranz
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

by:rav_chow
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

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

Please read all of my answer fully.

btw 10x for the support ;)
  Erez Sh.

 
0
 
LVL 18

Expert Comment

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

Author Comment

by:rav_chow
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

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

Expert Comment

by:erezsh
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

by:mgfranz
ID: 6290942
You do have IIS installed don't you?
0
 
LVL 1

Expert Comment

by:erezsh
ID: 6290951
(in days)
0
 
LVL 18

Expert Comment

by:mgfranz
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question