hey
i have a listview that shows logoff and log on for the user
with date
the listview show 12-6-2013 13-6-2013 and so on
how do i sort the date by using DTPicker ?
lets say a user loged in the system in 12-6-2013 and today is the 13-6-2013
al logs in the same date 12-6-2013 or 13-6-2013
i want to sort it with the DTPicker1
BTW this is the code that i use to load from the DB
tnx for the helpCode:Set RS = CN.Execute("SELECT * FROM Logs ORDER BY LogId") While Not RS.EOF Set Itm = FrmSecurityreport.LsVw.ListItems.Add(, , RS!LogId, , "report") Itm.Tag = RS!LogId Itm.bold = True Itm.SubItems(1) = RS!LogDate Itm.SubItems(2) = RS!LogDay Itm.SubItems(3) = RS!LogName Itm.SubItems(4) = RS!LogIn If Not IsNull(RS!logout) Then Itm.SubItems(5) = RS!logout End If If Not IsNull(RS!LogTotal) Then Itm.SubItems(6) = RS!LogTotal End If Bar.Value = Bar.Value + 1 RS.MoveNext DoEvents Wend End Sub




Reply With Quote