i have date in MM-YYYY format , i need to sort records based on Year in ascending order.

[yogeshrajamani]

i need to have sort as below

01-2016

02-2016

03-2016

01-2017

02-2017

03-2017

01-2018

02-2018

03-2018

[MarqueeCrew]

How about a formula for SORT_DATE

RIGHT([date],4) + "-" + left([date],2)

 that should sort well. 

cheers,

 mark

[Qiu]

@yogeshrajamani 
Lets just convert it to Date.

[grazitti_sapna]

Hi @yogeshrajamani,

Here is my take on this problem.

I hope it helps.