[bug] SfpegListCmp - Sorting a table by a column with date format DD/MM/YYYY

[ismailsalam]

Describe the bug : Sorting a table by a column with date format DD/MM/YYYY does not work correctly.

To Reproduce Steps to reproduce the behavior:

Go to the table view.
Click on the column header to sort by date.
Scroll down to observe the sorted order.
See error: Dates are not sorted correctly.
Expected behavior The dates should be sorted in ascending or descending order based on the DD/MM/YYYY

[pegros]

@ismailsalam Just saw your issue, as I was busy working on a complete repackaging as unlocked packages of my PEG_APEX (and soon PEG_LIST) reporitories. I shall have a look at this once this activity is done. my apologies for the latency.

[pegros]

@ismailsalam My apologies for reaching out so late.
I investigated this issue a little and tested with the standard close date field on a list of opportunities and I cannot reproduce your problem.
Dates are stored in YYYY-MM-DD format and, when choosing the "type":"date"format for the field in the datatablethe date format of the user is applied only for display.
When sorting the rows on the fields, the YYYY-MM-DD is used and the rows properly sorted.