sort by date

[Sshasnk]

I have to sort by date 

Date

12/2023 YE

1/2022 YE

1/2023 YE

3/2022 YE

2/2023 YE

The above data should be sorted to the latest date first

For example: 12/2023 is the latest and then 2/2023 and so on... 

[ShankerV]

Hi @Sshasnk 

One way of doing this.

Note: You can use the select tool to remove the columns Regexout1 and 2 also. Used for sorting purpose, post sort tool, it can be deselected using Select tool if needed.

Many thanks

Shanker V

[ShankerV]

Hi @Sshasnk 

One more way to avoid creating 2 columns for calculation.

Many thanks

Shanker V