4 Replies Latest reply: Mar 30, 2015 9:56 AM by Simon Hogg RSS

    Correct formatting of Dates - all my dates convert to January(?)

    Simon Hogg

      I have a load script;

       

            Date(Floor(Date#("[ZSALE_DT].[LEVEL01].[MEMBER_CAPTION]",'dd.mm.yyyy'))) as "Sale Date",

       

      This converts all my dates to "January".  The days are correct and the years are correct, but the month is always "01".  Any ideas?  (I suspect I don't need the FLOOR function - but I think I picked that up from somewhere as being necessary).