Sort months in string

[#1]

Hi guys,

I am using text box to show curremt selection:

='>> ' &

Year
& ' > '&concat(DISTINCT if(len(Quarter)>1,Quarter), ', ')
& ' > '&concat(date([DB Date]), ', ')

so in result I will have >>year>quarter>month

the problem is that if I will select more than 1 month it will sort months alfabeticaly.

Is there any way to stop sorting?

Thank you,

Andrzej

[rubenmarin]

Hi, maybe:

='>> ' &

Year
& ' > '&concat(DISTINCT if(len(Quarter)>1,Quarter), ', ')
& ' > '&concat(date([DB Date]), ', ', date([DB Date]))

If not, can you post a sample of the data to make tests?

[its_anandrjs]

In text i don't believe you sort it but you can use the straight table for this with only expression.

Regards,

Anand

[#4]

I am sorry I add wrong formula in OP

the formula from OP works fine as it has full date. but i want to show months only, and then it sorts incorrectly:

='>> ' &

Year
& ' > '&concat(DISTINCT if(len(Quarter)>1,Quarter), ', ')
& ' > '&concat(month([DB Date]), ',')

[MarcoWedel]

please post sample data/app

[tresesco · Accepted solution]

If you want the like: Jan, Feb, Mar.. then try like:

concat(Distinct month([DB Date]), ',', month([DB Date]))

the second 'month([DB Date])' defines the sort order.

[#7]

Thanks, this is what I needed. It works after little adjustment

concat(month([DB Date]), ', ',date([DB Date]))