(Xojo Plugin) Compute Difference Between Two DateTime Strings

Demonstrates how to compute the difference between two datetime strings.

Chilkat Xojo Plugin Download Xojo Plugin for Windows, Linux, Mac OS X, and ARM, ARM64

// Imagine we have these strings:

Dim t1 As String
t1 = "2022-11-14 15:45:38"
Dim t2 As String
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.
Dim sb1 As New Chilkat.StringBuilder
Dim success As Boolean
success = sb1.Append(t1)
Dim count As Int32
count = sb1.Replace(" ","T")
success = sb1.Append("Z")

Dim sb2 As New Chilkat.StringBuilder
success = sb2.Append(t2)
count = sb2.Replace(" ","T")
success = sb2.Append("Z")

// Load each into a CkDateTime
Dim dt1 As New Chilkat.CkDateTime
success = dt1.SetFromTimestamp(sb1.GetAsString())
// verify...
System.DebugLog(dt1.GetAsTimestamp(False))

Dim dt2 As New Chilkat.CkDateTime
success = dt2.SetFromTimestamp(sb2.GetAsString())
// verify...
System.DebugLog(dt2.GetAsTimestamp(False))

// Get the difference in seconds
Dim diffSeconds As Int32
diffSeconds = dt2.DiffSeconds(dt1)
System.DebugLog("Difference in seconds: " + Str(diffSeconds))
System.DebugLog("Difference in minutes: " + Str(diffSeconds / 60))