Filtering a date of type: 'string' as though it were type: 'date'

[Aaron]

Hello,

I am currently receiving the dates on my grid as strings and looking for a way to filter them as though they were dates. I tried simply changing the type in the schema from type: 'string' to type: 'date' and as far as the filtering goes this accomplished the goal, my problem now is that I can't seem to change the format of the dates being shown, I am only getting a full JavaScript date object showing as 'Tue Oct 13 2020 00:00:00 GMT-0700 (Pacific Daylight Time).'

Other than the format everything seems to be saving and updating as expected. I have tried simply adding format: "{0:dd-MMM-yyyy}" to the column as well as kendo.parseDate in the template. Any other possible solution I am missing?

Thank you in advance

[Petar]

Hello Aaron,

Are you converting the string 'date' to a Date object?

Here is a Dojo example that demonstrates how the Grid behaves when we pass a string date to its column and what happens when the same date is converted to a Date object. When the date is converted to a Date object, you can see that it is correctly formatted based on the definition in the "format" property of the column's definition. 

Check the linked example and let me know if it helps you resolve the issue in the application you are working on.

Regards,
Petar
Progress Telerik