This is a migrated thread and some comments may be shown as answers.

How to only filtering GridDateTimeColumn by Month and Year

3 Answers 425 Views
Grid
This is a migrated thread and some comments may be shown as answers.
VnDevil
Top achievements
Rank 2
VnDevil asked on 13 May 2012, 08:35 AM
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

3 Answers, 1 is accepted

Sort by
0
Accepted
Richard
Top achievements
Rank 1
answered on 16 May 2012, 06:09 PM
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!
0
Rayne
Top achievements
Rank 1
answered on 10 Jun 2013, 09:17 PM
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.
0
Accepted
Andrey
Telerik team
answered on 13 Jun 2013, 12:29 PM
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.
Tags
Grid
Asked by
VnDevil
Top achievements
Rank 2
Answers by
Richard
Top achievements
Rank 1
Rayne
Top achievements
Rank 1
Andrey
Telerik team
Share this question
or