Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Sort Table on date field

Avatar

Level 2

Hello Community,

I have the following dynamic table:

ID

Description

Date

Total

1000Shopping List01/01/2019 3:15 PM CET

17,45€

2000Shopping List01/05/2019 1:15 PM CET12,45€
3000Shopping List01/02/2019 4:42 PM CET21,01€
4000Shopping List01/03/2019 2:12 PM CET7,00€

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

ID

Description

Date

Total

2000Shopping List01/05/2019 1:15 PM CET12,45€
4000Shopping List01/03/2019 2:12 PM CET7,00€
3000Shopping List01/02/2019 4:42 PM CET21,01€
1000Shopping List01/01/2019 3:15 PM CET17,45€

Is there maybe a formcalc function to handle that?

I would be very pleased about support.

Thanks in advance

Jeemer

0 Replies

Avatar

Level 10

Hi Jeemer,

This sample from John Brinkman should help

Sort Subforms

Bruce