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
BedrockMission!

Learn more

View all

Sign in to view all badges

Sort Table on date field

jeemerj49157656
Level 2
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

1 Reply
_Bruce_Robertson
Level 10
Level 10

Hi Jeemer,

This sample from John Brinkman should help

Sort Subforms

Bruce