Date not sorting correctly

[janvsc]

Hi,

I am sending a date (JSON)  to pgdgrid in the following format: DD/MM/YY and the column is defined as { title: "Date", width: 70, dataType: "date", align: "right" }
The date is displayed correctly but when I click on the column header to sort, the column is sorted as MM/DD/YY

How do I correct this?

Regards

Jan

[paramvir]

Jan

It's because the grid doesn't understand the dd/mm/yy format.

For correct sorting and filtering, you need to format the date as yyyy/mm/dd or mm/dd/yy in JSON data while you can still display the date as dd/mm/yy in the view using column.render callback.

[janvsc]

Thank you for the quick response

All good now