Running Ignition 8.0.6, we have a table with a column full of timestamps. We set the columns.render property to “date” and sortable to true. When we sort the date column, it seems to be sorting based on the string-formatted time rather than the actual timestamp.
For example, if I had the dateFormat set to “MM/DD/YYYY” and sorted by date, I might see these items in this order:
Note that the “12/06/2019” entry is out of order, I suspect because ‘0’ comes after ‘2’ in string ASCII sorting. Even worse, I suspect that if I had another entry from January of 2019, it would show up adjacent to the Januar 2020 entry instead of at the beginning.
I expected the items to be sorted in chronological order.