How to only filtering GridDateTimeColumn by Month and Year

4 posts, 2 answers
  1. VnDevil
    VnDevil avatar
    58 posts
    Member since:
    Oct 2012

    Posted 13 May 2012 Link to this post

    Hi Telerik,

    I have an issue in my RadGrid, I only want GridDateTimeColumn filter data by month and year.
    Example: 1/2012 > Filtering all data in 1/2012

    Please tell me how to do that
  2. Answer
    jumpstart avatar
    479 posts
    Member since:
    Nov 2011

    Posted 16 May 2012 Link to this post


    An easy approach may be to use the RadMonthYearPicker in association with the RadFilter to filter your RadGrid GridBoundColumn using a datetime data type. This is covered by the following online demo: Filter/Custom Field Editors

    Hope this helps!
  3. DevCraft R3 2016 release webinar banner
  4. Rayne
    Rayne avatar
    241 posts
    Member since:
    Sep 2010

    Posted 10 Jun 2013 Link to this post

    Is there any way to do this without a filter control? I'd prefer to us the inline Grid filtering. I'm almost there, except for the actual's currently using the complete date, instead of just month/year and I really need month/year.
  5. Answer
    Andrey avatar
    836 posts

    Posted 13 Jun 2013 Link to this post


    You could check this online demo application which illustrates the functionality you need. The OrderDate and ShippedDate demonstrate the time independent and range filtering functionality of RadGrid. These two features could be combined to satisfy your requirement.

    Give this approach a try and you should not have problems.

    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Back to Top