UTC Time Diffs not working.. haaalp :(
This problem is causing me to pull my hair out. Assume this code: Log.Message "This account expires on " & sSQL(dba, strQuery, "expiration_date") & " (ETA: " & aqConvert.DateTimeTo...
Forum Discussion
I see it.
You're using aqDateTime.TimeInterval which only deals with the TIME portion of the DateTime. So, Now(), while it should include the date and time, actually is being formated down to a time only portion.
Try using, instead of aqConvert.DateTimetoFormatStr do
You won't get your nice "days, hours, minutes, seconds" verbage but it should report more correctly.
You're using aqDateTime.TimeInterval which only deals with the TIME portion of the DateTime. So, Now(), while it should include the date and time, actually is being formated down to a time only portion.
Try using, instead of aqConvert.DateTimetoFormatStr do
aqConvert.TimeIntervalStr(aqDateTime.TimeInterval(Now(), postExpDate))
You won't get your nice "days, hours, minutes, seconds" verbage but it should report more correctly.