comparing dates

[Ricky D]

I would like to know how to compare just the date part of a ticks value against the same from my sqlite db?

I can't make hours,minutes & seconds all 0 when I write the data to my sqlite so comparing current date to stored date never returns anyything.

regards, Ricky

 

[Ricky D]

found out how

   'strip off time values
   Dim t As Long
   Dim day,month,year As Int
   t = DateTime.Now
   
   u.ShiftDate = DateTime.DateParse(DateTime.GetMonth(t) & "/" & DateTime.GetDayOfMonth(t) & "/" & DateTime.GetYear(t))

cheers, Ricky