Hello all,
I am using vb.net express version. I have a datagridview which is popuated with data from an access database. I have all the data side working ok with the "Call Date" column set as datetime and sorted in date order assending within my application.

I also have a monthviewcalender on the form and wish to filter the datagridview by the date selected in the monthviewcalender to show appointments i may have on that date.

I have tried to populate the selected date into a textbox and use the following to filter:
Code:
AppointmentsBindingSource.Filter = String.Format("[Call Date] Like '" & TextBoxDate.Text) & "*'"
This causes a error. I have tried many different variants like:
Code:
AppointmentsBindingSource.Filter = ("[Call Date] Like '" & MonthCalendar1.SelectionRange.Start) & "*'"
The column is set as datetime in access and is system.datetime in the database explorers properties.

Can anyone help with this last little bit of code.

Thanks In Advance

Rich