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).
I would just use Date((Date#("[ZSALE_DT].[LEVEL01].[MEMBER_CAPTION]",'dd.mm.yyyy')) as "Sale Date",
Without Floor function. I worked with dates and Date(Date#,'dd.mm.yyyy')) format always worked perfect for me.
Yeah, honestly not sure why I'm using FLOOR (I *think* some of my 'dates' actually have datestamps). I'll leave it in for now (it seems to work) but might re-visit.