Android Question TicksPerDay in dates substracting

[advansis]

Hi guys, I was writing a function similar to DATEDIFF (VB6/VB.NET) and just wanted to get the number of days between two dates.
I did not understand why two consecutive days (D1 and D2 in this code) differ less than then the value of DateTime.TicksPerDay
I can use the ceil() function, but cannot understand this behaviour...

DateTime.DateFormat="yyyyMMdd"
Dim D1 As Long=DateTime.DateParse("20240331")
Dim D2 As Long=DateTime.DateParse("20240401")
Dim D0 As Long=DateTime.DateParse("20000101")

Log ("Diff 1-0: " & ((D1-D0)/DateTime.TicksPerDay)) ' returns 8856
Log ("Diff 2-0: " & ((D2-D0)/DateTime.TicksPerDay)) ' returns 8856.95833...
Log ("Diff 2-1: " & ((D2-D1)/DateTime.TicksPerDay)) ' returns 0.95833...

Thanks

 

[Erel]

Use DateUtils.PeriodBetweenInDays.

This is more complicated than it might seem due to DST changes.