This content has been marked as final. Show 4 replies
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).