Question

Sorting of Custom Date Time in a Datagrid

0

We're using the following datetime custom format in a datagrid and are sorting on this datetime: dd-MM-yyyy kk:mm:SSS I've noticed though the sorting is not correct. It only sorts correct untill the minutes, the SSS (milliseconds) are not sorted well. Is there anyway around this? Or is this a specific bug for a Mx. version? Using Mx. 4.8.7.

asked 2016-04-06

Tufan Yilmaz

2 answers

Jonathan Veldhuizen · Answer 1 · 2016-04-20

The seconds are missing in your date time format. That is not a problem, but be aware of the fact that the values are still sorted on the whole date time. The milliseconds part shows you only the fraction of a second, it does not contain the seconds multiplied by 1000. If you use dd-MM-yyyy kk:mm:ss.SSS, you will see that the ordering is correct.

Mitchel Mol · Answer 2 · 2016-04-06

You could add a separate attribute in which you transform the date to a unix timestamp and use that for sorting, although that would not help when the user manually adjusts the sorting. It will be more exact sorting. Also send in a bug support ticket to checkout if MX can resolve this issue.