RadGridView Filter Row Mode DateTime Filter

3 posts, 0 answers
  1. Nasir
    Nasir avatar
    18 posts
    Member since:
    Apr 2013

    Posted 24 Mar 2014 Link to this post


    We are using RadGridView Filter Row Mode for our column filters. In our Grids, we can have multiple days worth of data. The problem is, we allow formatting the date time. The value is provided by the user for the string format. The StringFormat of the DataMemberBinding is utilised here. So for example, if we have format hh:mm tt which would display time like 10:00 AM. What we want is, if the user chooses or types 10:00 AM, the grid should filter on all instances of 10:00 AM regardless of the Date part but currently it only  filters for the current day.

    Is there a way to allow this behavior? I would really appreciate a prompt response to my query.


  2. Nasir
    Nasir avatar
    18 posts
    Member since:
    Apr 2013

    Posted 25 Mar 2014 in reply to Nasir Link to this post

    Can anyone please reply, this is very urgent. I can submit a support ticket if you need me to.
  3. Dimitrina
    Dimitrina avatar
    3769 posts

    Posted 26 Mar 2014 Link to this post


    No matter what the converted values are, the real filtering is always done on the underlying original data. The formatting is used for UI purposes only. This means that if you have "DateTime"-> converted to -> "Time"  then the GridView will be filtered on "DateTime" as it is the "DateTime" that is the raw data. 

    In order to filter on the displayed values, you can create a property in your business object that holds the converted values ("Time"). Then you should set this property as a FilterMemberPath for that specific column. 
    I would suggest you to also check our online documentation to understand how the filtering is actually performed. 

    As another option you can try creating your own custom filtering control. You can check the article on applying your custom filtering logic.


    Build cross-platform mobile apps using Visual Studio and .NET. Register for the online webinar on 03/27/2014, 11:00AM US ET.. Seats are limited.

Back to Top