According to the Data Class documentation, the sorting of Date-time is planned for future release:
"5 Sorters
Each column has its own sorter. There are different types of sorters to pick from depending on the column data. Choose between a basic text sorter, a numeric sorter and a boolean sorter.
Note: More sorters, such as a data time sorter, are planned for future releases."
( i assume data time is a typo for datetime)
I achieved sorting by date like this:
Output of date is DATEFORMAT($myDate, 'mm-dd-yyyy') <- as String (This is what is visible in the table)
In the SORTER Tab of the DataColumn:
Type: Numeric
Index: $myDate.getTime()
If you'd like a 'default' sorting you can set a Direction as covered in the documentation.
Maybe such an example should be added in the documentation as long as the proper
sorter for date time is not implemented yet.
"5 Sorters
Each column has its own sorter. There are different types of sorters to pick from depending on the column data. Choose between a basic text sorter, a numeric sorter and a boolean sorter.
Note: More sorters, such as a data time sorter, are planned for future releases."
( i assume data time is a typo for datetime)
I achieved sorting by date like this:
Output of date is DATEFORMAT($myDate, 'mm-dd-yyyy') <- as String (This is what is visible in the table)
In the SORTER Tab of the DataColumn:
Type: Numeric
Index: $myDate.getTime()
If you'd like a 'default' sorting you can set a Direction as covered in the documentation.
Maybe such an example should be added in the documentation as long as the proper
sorter for date time is not implemented yet.
.