3 Replies Latest reply on Dec 31, 2018 11:50 AM by Norbert Maijoor

    Reformatting date fields: YM to match QTR

    Douglas Brockbank

      Currently, I have a 'YM' field with values like this:

       

      201701

      201702

      201703

      ...

      201801

      201802

      201803

       

      I also have a 'Qtr' field with values like this:

       

      2017-Q1

      2018-Q2

       

      (Fortunately, when I put 'YM' and 'Qtr' on 'Columns', it DOES correctly group the right way (e.g. On the top, it shows '201801', '201802' and '201803' and associates it correctly into  '2018-Q1'.

       

      How can I reformat my 'YM' field so it's consistent with the 'Qtr' field and is labeled like this:

       

      2017-M1

      2017-M2

      2017-M3

      ...