sort by date

Question

I have to sort by date

Date12/2023 YE1/2022 YE1/2023 YE3/2022 YE2/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 · Answer

Hi @Sshasnk

One more way to avoid creating 2 columns for calculation.

Many thanks

Shanker V

Another way sort by date.yxmd

ShankerV · Answer

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

sort by date.yxmd