Matrix: Sort by Date(-String)

[jup0]

Hi all,

I have a Matrix with a date-month in string format (text):

I want to sort it in the correct rank (top-down). The rersult should be:

2017-12

2017-11

2017-10

...

2017-1

2016-12

2016-11

...

I can only use this sort options:

Please help!

Many thanks

[quentin_vigne]

Hi @jup0

Did you try to go to the data tab, click the Modelisation tab and then click on "Sort by column"  ?

- Quentin

[jup0]

Yes - but no expected result: 

[quentin_vigne]

@jup0

Did you try to use an Order By YourColumn ASC in your server before importing it ? 

- Quentin

[jup0]

No - this is only 1 table - exported by another user.

I cant change the sql statement and import the data again. - i only got this table.

[quentin_vigne · Accepted solution]

@jup0

Maybe what you can do is extract the year from your column with 

Year = LEFT(YourColumn;4)

And do the same for your Month 

You will have two columns that will be more easy to order 

- Quentin