4 Replies Latest reply on Nov 17, 2012 1:24 PM by Marco Villar

    Calculated field for Date

      I have a dimension PERIOD in string format as '05-2012'  I want to make this as time series for trending analysis

       

      I tried DATE(LEFT[PERIOD],2)+"/01/"+RIGHT([PERIOD],4))

       

      it is throwing error .not a valid month...