This is a migrated thread and some comments may be shown as answers.
Applying Date Filter on column
5 Answers 50 Views
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Nikhil Kashyap
Top achievements
Rank 1
Nikhil Kashyap asked on 09 Aug 2010, 07:22 AM
Hi,
    Could you plz tell how to apply Date Filter for Column of type Date. Could you plz provide the syntax, how to achieve this?
Thanks

Nikhil
Customer Id: JT359876

5 Answers, 1 is accepted

Sort by
0
Atanas Korchev
Telerik team
answered on 09 Aug 2010, 07:27 AM
Hi Nikhil Kashyap,

 Filtering is demonstrated in the filtering example. There you can see how set a filter. Once you specify the DateTime property intellisense will guide you. Here is an example

        .Filterable(filtering => filtering
            .Filters(filters => filters
                .Add(o => o.OrderDate).IsGreaterThan(new DateTime(2010,8,9))
        ))

Regards,
Atanas Korchev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Nikhil Kashyap
Top achievements
Rank 1
answered on 09 Aug 2010, 10:50 AM
I mean i cant see date filter options in Date column - in UI.
I tried the following syntax, but its not working :

columns.Bound(o => o.OrderDate).Format("{0:MM/dd/yyyy}").Width(100);
        
 Do i need to do something else apart from this?
0
Atanas Korchev
Telerik team
answered on 09 Aug 2010, 10:58 AM
Hello Nikhil Kashyap,

I already showed you how to apply a date filter. The code you have pasted is for definding a bound column. I am not sure what exactly you are asking. Perhaps you have missed to enable filtering. To do so use the aforementioned Filterable() method.

All the best,
Atanas Korchev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Nikhil Kashyap
Top achievements
Rank 1
answered on 09 Aug 2010, 11:06 AM
Its working now. My Date Column Properties were not set to DateTime. Thanks
0
hari
Top achievements
Rank 1
answered on 21 Mar 2013, 01:11 PM
Hi,

i am working on MVC 3 Telerik grid, having DateAndTime column in grid, i am not able to filter the DateTime column,i want the grid to filter by both date and time.
if i use the column format to date,its working fine, but not working for both.Is there any solution to filter by both?

Thanks,
Tags
Grid
Asked by
Nikhil Kashyap
Top achievements
Rank 1
Answers by
Atanas Korchev
Telerik team
Nikhil Kashyap
Top achievements
Rank 1
hari
Top achievements
Rank 1
Share this question
or