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

[quriouss]

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).

[maxgro · Accepted solution]

try with upper

DD.MM.YYYY

mm is for minutes MM for month

[#3]

Hi ,

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.

Good Luck 

[quriouss]

Thanks - not sure why I missed that (well, I missed it because yyyy and dd works ...)

[quriouss]

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.

Thanks.