comparing dates

Ricky D

Well-Known Member
Licensed User
Longtime User
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
 
Sort by date Sort by votes

Ricky D

Well-Known Member
Licensed User
Longtime User
found out how

B4X: 
   '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
 
Upvote 0
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…