Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Want to calculate total minutes between start and stop date..

Status
Not open for further replies.

jrkrish

Technical User
Jan 21, 2002
11
0
0
US
I have start and stop date for each system outage detail record. What I want to know is, how can I calculate the total minutes between these two dates (I want to plot that in a graph..)

I tried with some FAQs and none of them are working.

Thanks in advance for your help..

 
Use the DateDiff function with an "n" argument:

DateDiff("n", {d1}, {d2})

Cheers,
- Ido ixm7@psu.edu
 
Thankyou Ido for the help. But the problem is right now I am using 7.0. I was not able to see any function with the name "Datediff". In this case, which method will be best to use.

Thanks,
Krish
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top