The simplest solution would be to use another date format, the ISO format: yyyy-MM-dd (e.g. 2020-11-01). Dates in the ISO format are naturally sortable.
If the date format in your screenshot must be preserved, then the solution would be to insert a 1st row with correctly formatted dates, and then use the “Label columns” action to label columns after the values in the 1st row.
The trick here is to ensure that the order of columns doesn’t change. For this, we will use the feature of the “Append table” action that preserves the order of column of the main table to which the other dataset is appended.
See example below.
date-labels.morph (3.9 KB)
