Problem to sort DATE in a listview

[papiosaur]

Hello,

i have a problem to sort correctly dates in a listview:



Any idea to correct that please?

[plouf]

idea n1 is to use "proper" programing date format which is YEAR-MM-DD , that way its "numeric correct" since day is the least significant
i.e. 2023-05-16 (month as two number digit always)

idea n2 is to keep date internal as unix format which is a raw number and react correct to sort, and then "format" it to display to user
i.e. GetTimestamp(#TIMESTAMP_UNIX)

[SamuraiCrow]

idea n1 is to use "proper" programing date format which is YEAR-MM-DD , that way its "numeric correct" since day is the least significant
i.e. 2023-05-16 (month as two number digit always)

To call that "proper" is to throw locale requirements in the trash and ignore date preferences set in the operating system's control panel.

idea n2 is to keep date internal as unix format which is a raw number and react correct to sort, and then "format" it to display to user
i.e. GetTimestamp(#TIMESTAMP_UNIX)

Now that is the proper way!