Month Field Sorting

[rish]

I created a month field using the following expression:

Month(DateField)&' '&Year(DateField)

But I can't sort it properly, I was able to get it sorted in the order of years but not with months. Can anybody help me with this? what expression can i use for this? 

[sunny_talwar · Accepted solution]

Create it like this instead

Date(MonthStart(DateField), 'MMM YYYY')

[rish]

Hi thanks, it works!!!