Hello KR,

I am preparing a grid using the DataTables Widget.

The issue in sorting of date field (dd-mm-yyyy)

1. In databse the datetime format is "yyyy-mm-dd h:i:s"
2. I am successfully able to display "dd-mm-yyyy" format
3. the field is not sorting properly! when I sort the date the sorting is not doing well.

in datatable plugin there is "date-eu" plugin (https://datatables.net/plug-ins/sorting/date-eu)

I have no idea how to integrate this plugin or is there a inbuilt way around to fix this?

Thanks it worked.