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

Filtering a DateTimeColumn that displays time

1 Answer 50 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Chad Johnson
Top achievements
Rank 1
Chad Johnson asked on 20 Mar 2012, 02:28 PM
I am trying to filter a GridDateTimeColumn that has the the DataFormatString = "{0:MM/dd/yyyy hh:mm tt}" and PickerType ="DatePicker"

The DataField = "ReferralDate" which is a Nullable<DateTime> property on my business object.

I would like to filter on date and simply ignore the time.  For example if the data in the grid contains:

3/11/2012 3:23 PM
1/4/2011 12:00 AM
3/11/2012 12:00 PM

Applying the filter "3/11/12" "EqualTo" will produce the following:

3/11/2012 3:23 PM
3/11/2012 12:00 PM

 I've been looking through the forums for a solution and found lots of posts related to GridDateTimeColumns and filtering which I'm finding to be either incomplete as far as a solution goes or not really applying to my specific need.  Any help/direction would be appreciated!

1 Answer, 1 is accepted

Sort by
0
Jayesh Goyani
Top achievements
Rank 2
answered on 20 Mar 2012, 03:11 PM
Hello,

Please look in below link for solution.
http://www.telerik.com/help/aspnet/grid/grdfilteringfordatetimecolumnwithdataformatstring.html

Thanks,
Jayesh Goyani
Tags
Grid
Asked by
Chad Johnson
Top achievements
Rank 1
Answers by
Jayesh Goyani
Top achievements
Rank 2
Share this question
or