Date difference in minutes

Posted by zurna on Stack Overflow See other posts from Stack Overflow or by zurna
Published on 2010-04-13T22:44:56Z Indexed on 2010/04/13 22:53 UTC
Read the original article Hit count: 231

Filed under:

asp-classic

I have DateFirstStarted and DateEnded fields in the database.

Date values are recorded as

DateFirstStarted
04/13/2010 07:00:00.000 PM
DateEnded
04/13/2010 09:00:00.000 PM

How do I print minute difference between two dates. I tried the following code but it returned something like 999343

Clock   =   DateDiff("m", objLiveCommentary("DateFirstStarted"), objLiveCommentary("DateEnded"))

Related posts about asp-classic

Looping through an array and calling a function on each pass in v-basic / asp classic

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I loop through an array and call a function on each pass? At the minute I'm trying the following... if Request.Form("authorize") <> "" then dim post_ids, ids post_ids = Request.form("authorize") ids = split(post_ids, ",") For i = LBound(ids) to UBound(ids) … >>> More
ASP Classic Session Variable Not Always Getting Set

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a classic ASP site I'm maintaining and recently we wanted to do special rendering actions if the visitor was coming from one specific set of websites. So in the page where those visitors have to come through to get to our site, I put a simple line setting a session variable: <!-- #include… >>> More
ASP Classic page quit working

as seen on Stack Overflow - Search for 'Stack Overflow'
I've had a set of legacy pages running on my IIS7 server for at least a year. Sometime last week something changed and now this line: Response.Write CStr(myRS(0).name) & "=" & Cstr(myRS(0).value) which used to return nothing more exciting than the string: 'Updated=true' (the sproc processing… >>> More
in visual studio 2008, when I stop debugging an asp classic website visual studio always crashes

as seen on Stack Overflow - Search for 'Stack Overflow'
We are running visual studio 2008 (with the service pack) and having troubles when we are debugging an asp classic website. We can attach to the w3p process and debug just fine. breakpoints work, we can view variable values. The difficulty arises when it comes time to detach or stop the debugger… >>> More
HTML to PDF conversion from hosted ASP classic?

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to convert HTML to PDF on the fly from a hosted ASP classic page. WkHtmlToPDF is great, but unfortunately requires installation on the server which is not possible in this case. Is there something out there that would do this? >>> More

Developer IT

Date difference in minutes - Developer IT

Date difference in minutes

asp-classic

Related posts about asp-classic

Looping through an array and calling a function on each pass in v-basic / asp classic

ASP Classic Session Variable Not Always Getting Set

ASP Classic page quit working

in visual studio 2008, when I stop debugging an asp classic website visual studio always crashes

HTML to PDF conversion from hosted ASP classic?

Categories cloud