Nageshwar Rao

Nageshwar Rao

  • NA
  • 74
  • 35.6k

Filter not working for DateTime columns with "equal To" filt

Oct 5 2016 4:59 AM
I can't get the filters for 'equal to' working on date time column in rad grid. As far as I can tell this has something to do with the times on the dates.
The date time column in database is saved as '2013-07-26 00:01:09.840' format. whereas in the grid the value is displayed as '7/26/2013 12:01:09 AM'. This should not be a problem as far as I think.
I am giving the value '7/26/2013 12:01:09 AM' in the text box to search with Filter option as 'Equal To'. No results are returned when I have selected this value from the grid itself.

Greater than and Less Than filter options work fine. Just the equal to is not.

Please tell me what is wrong here. 

Answers (8)