RowFilter - filter rows between two dates

Hi Experts,

I have a table that includes 'custID' and 'invDate' columns.

I would like to apply a rowfilter to this to show only the results for a certain custID where the invoices fall between a start and finsih date (selected by the user with DateTimePicker1 & DateTimePicker2)

I've attempted numerous variations on the code below but can't get it to work with dates. Any Ideals?

********************************************************
Dim dv As DataView = MasterDataSet1.Tables("Invoices").DefaultView

dv.RowFilter = "[custID]=" & Me.DmIDTextBox.Text & " AND [invDate] >=#"  & Me.DateTimePicker1.Text & "# AND [invDate] <=#" & me.DateTimPicker2.Text & "#"

Me.InvoiceBindingSource.DataSource = dv
********************************************************

I've tried with and without the '#', with Me.DateTimePicker1.Text and Me.DateTimePicker1.value Me.DateTimePicker1.value.date etc.... but can't get it to work.

Thanks in advance,

SamBStart Free Trial