5 Replies Latest reply on Jan 31, 2019 7:47 AM by Andrew Bickert

    How to create a +YEAR  (expanded field) on 'Columns' using a current STRING field YYYYMM

    Douglas Brockbank

      I have a field called 'YYYYMM' which is a STRING and must convert to a date data type using a formula. I want to then drag it onto the 'Columns' field and have the +YEAR, so I can drill down on +QUARTER, and +MONTH appear

       

      Values in 'YYYYMM'

      201701

      201702

      ...

      201712

      201801

      201802

      ...

      201812

      201901