How we can ORDER BY Month names in calender format

Question

I have a field of Period name with values like Aug-22, Sep-22, June-22, May-22,...

How i can able to order by this period name in a Calender manner May-22, June-22,Aug-22, Sep-22,..

Gianni Ceresa · Answer

Set a sort order column on that logical column pointing to a column having a format that can be sorted, something like YYYY-MM.