sortingFn seems like not working well

[WohKX]

Currently, I am working on customizing the sorting function for certain column. However, it seems like not working well and I am pretty sure that the function could return properly (-1, 0, 1). The code snippet is as below:

`
const c_DateSortingFn = (rowA, rowB, col) => {

var dateA = rowA.original[col];
var dateB = rowB.original[col];
var _dateA = moment(dateA, "DD/MM/YYYY hh:mm:ss A", true);
var _dateB = moment(dateB, "DD/MM/YYYY hh:mm:ss A", true);
return _dateA.isAfter(_dateB) ? -1 : _dateB.isAfter(_dateA) ? 1 : 0;
}

const columns = [
...
{
accessorKey: "UPDATE_DATETIME",
header: "Last Update",
size: 200,
Cell:({cell}) => (cell.getValue() === null) ? (<> - </>) : cell.getValue(),
sortingFn : (rowA, rowB, columnId) => {c_DateSortingFn(rowA, rowB, columnId)}
},
...
];`

Did I missed out anything? Thanks for your time.

[KevinVandy]

Sorry, I'd need more specifics than "not working well" in order to help. If you are providing your own sortingFn, it is up to that code to perform sorting correctly. Make a code sandbox reproducing the issue and I could help.

[WohKX]

Yes, I am providing my sortingFn and here is the link for code sandbox:
https://codesandbox.io/s/material-react-table-sample-custom-sortingfn-forked-spk8d3

[KevinVandy]

check out the advanced example for advice on how to sort dates

[WohKX]

Currently my requirement was achieved according to the example. Thanks!