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!
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!