(Classic ASP) Compute Difference Between Two DateTime Strings

Demonstrates how to compute the difference between two datetime strings.

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' Imagine we have these strings:

t1 = "2022-11-14 15:45:38"
t2 = "2022-11-16 17:23:41"

' How many minutes are between the two?

' First, we'd want load each date/time into a Chilkat CkDateTime object.
' In this case, there are no CkDateTime methods that accept the above format.
' However.. the CkDateTime's SetFromTimestamp will accept a date in the format "YYYY-MM-DDThh:mm:ssZ"

' First modify the above dates to the timestamp format.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sb1 = Server.CreateObject("Chilkat.StringBuilder")
success = sb1.Append(t1)
count = sb1.Replace(" ","T")
success = sb1.Append("Z")

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sb2 = Server.CreateObject("Chilkat.StringBuilder")
success = sb2.Append(t2)
count = sb2.Replace(" ","T")
success = sb2.Append("Z")

' Load each into a CkDateTime
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.CkDateTime")
set dt1 = Server.CreateObject("Chilkat.CkDateTime")
success = dt1.SetFromTimestamp(sb1.GetAsString())
' verify...
Response.Write "<pre>" & Server.HTMLEncode( dt1.GetAsTimestamp(0)) & "</pre>"

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.CkDateTime")
set dt2 = Server.CreateObject("Chilkat.CkDateTime")
success = dt2.SetFromTimestamp(sb2.GetAsString())
' verify...
Response.Write "<pre>" & Server.HTMLEncode( dt2.GetAsTimestamp(0)) & "</pre>"

' Get the difference in seconds
diffSeconds = dt2.DiffSeconds(dt1)
Response.Write "<pre>" & Server.HTMLEncode( "Difference in seconds: " & diffSeconds) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( "Difference in minutes: " & diffSeconds / 60) & "</pre>"

%>
</body>
</html>