7 Replies Latest reply on Aug 3, 2016 12:03 PM by tim.latona

    Convert numeric (YYYYMM) into  Date

    Maru Pihema

      I have a numeric variable coming through my data - let's call this [txn_yr_mth] - in the following format 'YYYYMM' - for example '201601' and I want to convert this into a date that I can use for analysis

       

      i.e. '201601' should be January-2016

       

      Any assistance would be appreciated.