Sort Dataset by date in european notation

[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…