Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Create it like this instead
Date(MonthStart(DateField), 'MMM YYYY')
Hi thanks, it works!!!