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
    Thanks
  2. Answer
    jumpstart
    jumpstart avatar
    479 posts
    Member since:
    Nov 2011

    Posted 16 May 2012 Link to this post

    VnDevil:

    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. UI for ASP.NET Ajax is Ready for VS 2017
  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 comparison...it's currently using the complete date, instead of just month/year and I really need month/year.
  5. Answer
    Andrey
    Admin
    Andrey avatar
    836 posts

    Posted 13 Jun 2013 Link to this post

    Hi,

    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.

    Regards,
    Andrey
    Telerik
    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