Concatenated Field Sorting

[Uma7]

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!

[SunilChauhan]

go to Sorting  by expression

and Use below

 Yearfield&'-'&num(Monthfield)  or 

 Yearfield&num(Monthfield)

[tresesco · Accepted solution]

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

[BrunPierre]

 Use in the sort expression.

=Floor(YearMonthField)

[tresesco]

@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.

[Uma7]

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