Kendo Grid Filter Date Column with format

[Federico]

Kendo Grid Filter Date Column with format:

Hello,

I have a kendo grid with a date column

I'd like to create a filter for this column 

The fitler would be a calendar (datepicker)

The Back-end returns this date format: "2018-11-07T00: 00: 00.000"

Then the date will be converted into the column template

-------------------------------------------------------------------------------

Column of grid:

field: 'dateA', title:'"Date"',width:175, template: kendo.template($('[id=myTemplate]').html()),format: '{0:"dd-MM-yyyy "}',filterable: {ui: 'datepicker'}},"

 

-----------------------------------------------------

<script id="myTemplate" type="text/x-kendo-template">

#if(!Utils.isNullOrUndefined(dateA)){#

#:kendo.toString(kendo.parseDate(dateA, "yyyy-MM-ddTHH:mm:ss"), "dd-MM-yyyy")#

 #}else{#

 -

#}#

</script>

 

The filter does not work.

I'd like to filter date with this format " dd-MM-yyyy" using calendar widget

How can I solve this problem?

 

[Georgi]

Hi Federico,

Based on the provided information I assume that the requirement is to change the format of the filter widget. Please correct me if I am wrong.

A possible solution is to create a custom date picker filter widget and configure it as required.

e.g.

filterable: {
  ui:function(element){
    element.kendoDatePicker({
      format:'{0: dd-MM-yyyy}'
    })
  }
}

Below you will find a small sample which demonstrates the above approach:

• https://dojo.telerik.com/UTuKuVaS

Regards,
Georgi
Progress Telerik

[Shoji]

How do you create a DatePicker when mode is "row"? The ui function does not seem to be called when mode i "row". Thanks.

  filterable: {
              mode: "row",I

[Georgi]

Hi Shoji,

When in row filter mode you have to pass the handler to the column.filterable.cell.template setting.

Regards,
Georgi
Progress Telerik

[Shoji]

I got it! Thanks!