2 Replies Latest reply: Jan 8, 2016 11:55 AM by Sébastien Fatoux RSS

    Problem changing to another Date Format

    Jim Chan

      HI there,

       

      I am problem changing from "42005" date format to "201501" . although both table's KPI_DATE have been linked together. How can i make it to same? below is the format i have applied, resulted "42005" after the changes.

       

      Date(Date#(KPI_DATE, 'YYYYMM'), 'YYYYMM') as KPI_DATE,

      error.png

       

      Rgds,

       

      Jim