Xojo Plugin

Compute Difference Between Two DateTime Strings

Demonstrates how to compute the difference between two datetime strings. Xojo Plugin

// 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))