How to Sort Month Year

[JishnuGS]

Hi,

I want to sort the month year in the below order, could anyone help me.

Required order,

Current order,

Thanks, Jishnu

[QFabian]

hi, you need  date (number) field for sorting

as i can see, your data field is atachec to the left, so is text.

you can create your date field with that text using mid, replace functions, then  makedate()

[Kushal_Chawda · Accepted solution]

@JishnuGS  you can create a field which stores number value of Month/Year field and then use that field in sort expression

floor(date(date#([Month/Year],'MMMM YYYY'))) as [Month/Year Num]

[JishnuGS]

Hi @Kushal_Chawda,

Perfect Thanks!!