Hi,
I have a column which DataType is TimeSpan, TimeSpans are displayed in military time format("hhmm"), however when user types 2000, filter interprets it as 2000 days 0 hours 0 minutes 0 seconds(2000.00:00:00). Filter checkBoxes also display values in the format specified. How can I make filter parse 2000 as 0.20:00:00?
Is there an easy way to do this?