DataTable and Dates

[wtrudell360]

Is there a way to format a Date within the datatable and have it sort correctly as a Date? I can format it and have it display the way I need but it of course sorts a text not as a Date.

[tay1orjones]

Hi @wtrudell360, custom sorting is supported through the sortRow prop available on DataTable. Through it you provide your own function to control sorting beyond the default text sort. Full info is available in the DataTable Custom Sorting docs in storybook

[wtrudell360]

Thanks

[vmukhachev]

@tay1orjones , could you please explain how to use it for dates sorting? custom "sortRow" function receives the formatted value and it is not possible to get the raw values without parsing them.

[tay1orjones]

@vmukhachev Yeah, you'll probably need to parse them for thorough comparison. You might find something like moment.js helpful in this scenario, but generally speaking it should be performant to parse the date as part of the comparison between values.

Worth noting that depending on the format you can rely on the strings being compared.

if ("2022-05-31" < "2012-06-01") {
    return -1;
}