Is the a standard way of setting the default filter in the vb code-behind for a GridDateTimeColumn that has RangeFiltering?
My problem is not with making the initial FilterExpression string, but rather how to set the boxes so that if someone filters by a different value without manually setting the dateTimePicker, the values will still be picked up for the FilterExpression.
I have thought up alternate solutions to this problem like storing my starting value. Because of some rarities in my code, I view and edit my FilterExpression every time a filter is called, therefore when a filter is changed I can see if the FilterExpression contains the GridDatePickerColumnFilter filtering information and if it does not (meaning that nobody has manually changed the dateTimePicker fields) then i can re-add it myself from the labels (or recalculate it again).
Unfortunately this requires alot of additional code and paying close attention. I would be really appreciative if someone knows if there is a way to set the dateTimePicker similar to how "column.CurrentFilterValue = [string]" will set the filter textbox so that the next time a filter is called or the table is rebound, it still remember the filter value.