BindingSource Filter Between Two Given Date

[snachala]

Hi All,
Im thinking if it is possible to filter records based on date1 and date2.
All this time Im using a different approach to filter it. I just put the
command like

"Select * From Invoices Where InvoicesDate Between DateValue('" + SelectedDate1.ToShortDateString + "') And DateValue('" + SelectedDate2.ToShortDateString + "') ORDER BY SO_NO DESC"


I've been using bindingsource.filter to filter it for a certain date but
is it possible if i select all records and filter it between a period?
What the syntax would be like to filter it between two given dates?


Thanx