Need to filter binding source on date value
The table field [recordaddeddate] is a Date/Time field in my Access database. Usually this field contains a date + time value. For filtering on my datagridview I want to filter on the date portion only. However the following genterates a 'The expression contains an unidentified function call DateValue' error. How can I filter on just the date?
Code:
DateSelected = DateValue(Me.AddedDateDateTimePicker.Value)
Me.ConversationTblBindingSource.Filter = "DateValue([recordaddeddate]) = #" & DateSelected & "#"
Re: Need to filter binding source on date value
The BindingSource has no knowledge of your Access database. It only supports what the documentation says it supports. I'm sure that you've read that documentation.
If you want to test just the date then you can test that the date & time is greater than or equal to some date and less than one day later than that date.