Hi,
I have an historical binding on a table that outputs some values with its registration date.
When I try to sort the table so it’s displayed in discending order (from the newest data to the oldest) I get a strange order, probably because ignition doesn’t recognized the date format DD/MM/YYYY.
Having the Perspective table component do the sorting on date columns has never been quite right. It converts all of the dates to strings and then sorts them in ASCII order.
The best we ever found was sorting the data while still in dataset format before providing it to the Perspective component:
I read the discussion with your answer in it and I saw that the user lwood suggested to set the column to auto instead of date (in the properties tree just set “render:auto”) and it worked out for me.