13 Replies Latest reply: Jul 13, 2017 7:59 AM by Piet Hein van der Stigchel RSS

    Can't format date in Load Script

    Natalie Watson

      Hi guys,

       

      I don't understand what is causing this problem. I have a date field which I extract from a SQL server using cast(date as date) function, which returns an ISO format YYYY-MM-DD.

       

      In the Master Calendar autogeneration script, i'm trying to format the date like:

       

      date(date#([Date], 'YYYY-MM-DD'),'DD/MM/YYYY') as Date.

       

      I have a basic fact table, and a master calendar table for this particular date field, however, it is displaying in YYYY-MM-DD format. I've tried the above formula on the field in the fact table and in the master calendar, and it still displays incorrectly.

       

      What's going on?

       

      Capture.PNG