Lianja

Compute Difference Between Two DateTime Strings

Demonstrates how to compute the difference between two datetime strings. Lianja

// Imagine we have these strings:

lcT1 = "2022-11-14 15:45:38"
lcT2 = "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.
loSb1 = createobject("CkStringBuilder")
loSb1.Append(lcT1)
lnCount = loSb1.Replace(" ","T")
loSb1.Append("Z")

loSb2 = createobject("CkStringBuilder")
loSb2.Append(lcT2)
lnCount = loSb2.Replace(" ","T")
loSb2.Append("Z")

// Load each into a CkDateTime
loDt1 = createobject("CkDateTime")
loDt1.SetFromTimestamp(loSb1.GetAsString())
// verify...
? loDt1.GetAsTimestamp(.F.)

loDt2 = createobject("CkDateTime")
loDt2.SetFromTimestamp(loSb2.GetAsString())
// verify...
? loDt2.GetAsTimestamp(.F.)

// Get the difference in seconds
lnDiffSeconds = loDt2.DiffSeconds(loDt1)
? "Difference in seconds: " + str(lnDiffSeconds)
? "Difference in minutes: " + str(lnDiffSeconds / 60)


release loSb1
release loSb2
release loDt1
release loDt2