Sort Dataset by date in european notation

[daniele1]

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.

Any solution?
Thanks

Daniele

[justin.brzozoski]

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:

[Bug-2737] Perspective table - sorting date column

In the long run, we used something similar to this as a transform on our dataset binding, so the table is pre-sorted by dates: def sort_dataset_by_date(dset, date_column, ascending=True): orig_columns = system.dataset.getColumnHeaders(dset) tstamps = [system.date.toMillis(x) for x in dset.getColumnAsList(date_column)] dset = system.dataset.addColumn(dset, 0, tstamps, 'tmp_tstamp', long) dset = system.dataset.sort(dset, 0, ascending) return system.dataset.filterColumns(dset, orig_columns) I…

[nminchin]

@justin.brzozoski

converts all of the dates to strings and then sorts them in ASCII orde

If that's the case, then should be able to use ISO 8601 date format (yyyy-MM-dd)

[daniele1]

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.