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

I am finding it difficult to understand your question, you're already filtering your records in the sql query based on the date. what other syntax you need?

Don't worry about it. I doubt that the cross forum sig link dropping OP will be back to check.