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 · Accepted solution]

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.

[Stiltsoft support]

Hi @Janice ,

Please add a few custom tags for us:

• table-filter
• table-filter-and-charts
• table-transformer

Thank you!