I am using Kendo Grid in which I have added a column for displaying date and time and I have used kendo grid date filter for filtering datetime. But the problem I am facing is that I am not able to filter the datetime by selecting isequalto option from filter .
I tried to do this on my column, but it didn't work:
columns.Bound(o => o.Time).Title("Time").Format("{0:MM/dd/yyyy HH:mm:ss}").Filterable(f => f.UI("DateTimeFilter")).Width("5%");
And have applied below script :
<script type="text/javascript">
function DateTimeFilter(control)
{
$(control).kendoDateTimePicker();
}
</script>
The above code works when I select exact datetime from datetimepicker but it doesn't work when I select isequalto.
For eg : If I have this datetime "12/21/2013 07:15:45" displayed in my kendo grid column and when I copy this datetime to isequalto option under filter it does not gives any data.
I will be thankful if anybody could help me out in solving my issue. Thanks in advance.
I have attached a link for sample project to clarify my above problem clearly. In that I have added a datetime column in the grid but when I try to filter through the datetime shown in grid (ie. by copying it to the filter) it display empty grid after reloading.
You can find Sample Project Here
I have also attached a image below where I have added description of my problem. You can find link for image here Please help me out in solving my issue.
