Question Filtering DataGridView through two columns

[Rafiki]

Hey everyone,

I need to filter my data grid view through two columns, first one being by date, and the other as time. Each entry has it's own date and time. I've only managed to filter the database by date with the following code

VB.NET Code:

1. TimeLogBindingSource1.Filter = String.Format("currentDate >= #{0:M/dd/yyyy}# AND currentDate <= #{1:M/dd/yyyy}#", dtpStart.Value, dtpEnd.Value)
   

​

If I edit a time in an entry, it has to move to it's correct place in the data grid view but it stays in the same spot.

I'd appreciate any help. Thank you!