Sort Table on date field

[jeemerj49157656]

Hello Community,

I have the following dynamic table:

ID	Description	Date	Total
1000	Shopping List	01/01/2019 3:15 PM CET	17,45€
2000	Shopping List	01/05/2019 1:15 PM CET	12,45€
3000	Shopping List	01/02/2019 4:42 PM CET	21,01€
4000	Shopping List	01/03/2019 2:12 PM CET	7,00€

Is it possible to sort by Date and begin with the latest entry? Ideally this should be the output:

ID	Description	Date	Total
2000	Shopping List	01/05/2019 1:15 PM CET	12,45€
4000	Shopping List	01/03/2019 2:12 PM CET	7,00€
3000	Shopping List	01/02/2019 4:42 PM CET	21,01€
1000	Shopping List	01/01/2019 3:15 PM CET	17,45€

Is there maybe a formcalc function to handle that?

I would be very pleased about support.

Thanks in advance

Jeemer

[_Bruce_Robertson]

Hi Jeemer,

This sample from John Brinkman should help

Sort Subforms

Bruce