topic Re: Concatenated Field Sorting in App Development

Concatenated Field Sorting

Uma7 — Fri, 15 Nov 2024 21:40:36 GMT

Hi,
i have 2 string fields year and month which i concatenated to create year-month field for graphs.
I need to sort in ascending order to show in graph .

How to do this?
Can anyone help me?
Thanks in advance!

Re: Concatenated Field Sorting

SunilChauhan — Fri, 16 Jun 2023 06:17:20 GMT

go to Sorting by expression

and Use below

Yearfield&'-'&num(Monthfield) or

Yearfield&num(Monthfield)

Re: Concatenated Field Sorting

tresB — Fri, 16 Jun 2023 06:42:04 GMT

Sort by expression: =Date#(year&month, 'YYYYMMM')

Re: Concatenated Field Sorting

BrunPierre — Fri, 16 Jun 2023 06:53:59 GMT

Use in the sort expression.

=Floor(YearMonthField)

Re: Concatenated Field Sorting

tresB — Fri, 16 Jun 2023 06:59:49 GMT

@Uma7 , it's good that you appreciate responses by 'Like'ing it. However, it would also be nice for fellow comm visitors to know which solution(s) worked for this problem. Please mark the 'correct' that works for you.

Re: Concatenated Field Sorting

Uma7 — Fri, 16 Jun 2023 07:00:23 GMT

will accept the one which works in my use case working on it