4 Replies Latest reply on Jun 19, 2018 11:04 PM by Cha Loon Chai

    Group date range into monthyear

    Cha Loon Chai

      Hi,

       

      I have a set of data where I need to group it into monthyear format.

      The data format is as below and attached excel sample.

       

      DatePeople
      201806051
      201806042
      201806033
      201806024
      201806015
      201806016
      201805301
      201805292
      201805253
      201805204
      201805105
      201805026
      201804301
      201804292
      201804253
      201804204
      201804105
      201804026

       

      The format that I am searching for is "Jan 2018" , "Feb 2018".

       

      I tried using calculated field but it contains strings error, and I am not sure how to move on from here.

       

      Appreciate if anyone can help out.

      Thank you.