I would like to group a list by Month Year in SharePoint online. I've a calculated field that returns the date as text in the format "YYYYMM¤MMM-YY" e.g. "201806¤Jun-18" to allow sorting in the correct date order. I would however like to hide everything before the ¤ symbol yet maintain the correct order for sorting so that I get items grouped in chronological order under headings displaying as Feb-17;Jun-17;Jul-17;Aug-17;Dec-17;Feb-18;Mar-18;Jul-18 and not alphabetically like Aug-17; Dec-17; Feb-17; Feb-18; Jul-17; Jul-18; Jun-17; Mar-18; etc.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.