How to sort by date in table excerpt include macro?

Moritz Ehrle

I created a table with the table excerpt include macro. Now I want to sort the rows by the "date" column. The sort function of the table filter macro doesn't work.
Is there any other way?

Stiltsoft support

Hi @Moritz Ehrle ,

You may try the Table Transformer macro: go to the Settings tab and choose the correspondent Date format.

Then you may use smth like this for your SQL query:

SELECT * FROM T*
ORDER BY 'Date' ASC

Here the 'Date' column is your column with dates.