I'm trying to filter a binding source to the changing of a dateTime picker from on the same form
I'm getting this error:
'syntax error: Missing Operand after 00 operator'
DiveDetailsListingsBindingSource.Filter is returning "diveDate Like 25/02/2009 00:00:00"
Thanks
Private Sub datePickerSurveyList_ValueChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles datePickerSurveyList.ValueChangedDiveDetailsListingsBingingSource.Filter = "diveDate Like " & datePickerSurveyList.Value.Date.ToString()End Sub
You were right about the delimiters and the equals,
This worked in the end
"diveDate=' " & datePickerSurveyList.Value