Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to sort the month year in the below order, could anyone help me.
Required order,
Current order,
Thanks, Jishnu
@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]
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()
@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]
Hi @Kushal_Chawda,
Perfect Thanks!!