Filter DateTime column search with DateTime picker

[Richard]

I have a Kendo MVC Grid that has a column with a DateTime column.    Everything looks good and formats correctly.   When i filter,  it gives me a date picker and a time picker.  When i remove the DateTimeFilter Template below and use template contains,  it will give me a Date picker (which i want),  but still wants to filter by the date and time..     Is there a way i can have the date and time all as the same field,  but only filter with a Date picker.?     Example:  i use the Date picker to pick 07/24/2017 and it filter everything on that date regardless of time..      Or do they need to be completely different fields,  or even concatenated fields in the same column.?

 

the Column data looks as such:  07/24/2017 18:12:00 

columns.Bound(c => c.CreatedDate).Title("Submitted On")

.ClientTemplate("#= kendo.toString(kendo.parseDate(CreatedDate), 'MM/dd/yyyy HH:mm:ss') #")

.Filterable(ftb => ftb.Cell(cell => cell.Template("DateTimeFilter")));

[Georgi]

Hi Richard,

It is possible to achieve filtering by date regardless of time using two DateTime properties in the binding ViewModel, e.g:

public class MyViewModel
{
       public int Id { get; set; }
       public DateTime CreatedDate { get; set; }
       public DateTime CreateDateOnly { get { return (this.CreatedDate.Date); } }
}

CreateDate would contain datetime original data from database. CreateDateOnly would contain date only data calculated from CreateDate.

The column configuration should look like this:

columns.Bound(x => x.CreateDateOnly).ClientTemplate(" #= kendo.toString(CreatedDate,\"dd/MM/yyyy hh:mm:ss\") #");

In other words, the field with the date and time is displayed but the column is filtered by the field that contains only the date.

For convenience I created a simple (filter-date-only.zip) project which illustrates such approach in action.


Regards,
Georgi
Progress Telerik