Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
quriouss
Creator III
Creator III

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

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try with upper

DD.MM.YYYY

mm is for minutes MM for month

View solution in original post

4 Replies
maxgro
MVP
MVP

try with upper

DD.MM.YYYY

mm is for minutes MM for month

Not applicable

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
Creator III
Creator III
Author

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

quriouss
Creator III
Creator III
Author

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.