Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
holymosfet
Contributor III
Contributor III

Formatting from number to date bug

Hi everyone,

I'm trying to convert a number dimension in the format YYMMDD to a date using date#() and date().


Does anyone know what causes this weird behaviour?
The month number gets changed from 10 to 01.

holymosfet_1-1669297869910.png

 

 

Thank you!

Labels (3)
1 Solution

Accepted Solutions
Or
MVP
MVP

Try using YYMMDD rather than yymmdd (uppercase, not lowercase). Lowercase 'm' is for minutes.

View solution in original post

3 Replies
Or
MVP
MVP

Try using YYMMDD rather than yymmdd (uppercase, not lowercase). Lowercase 'm' is for minutes.

holymosfet
Contributor III
Contributor III
Author

Whoop! Fixed it. Thank you 😊

sidhiq91
Specialist II
Specialist II

@holymosfet  Could you please try the below code?

NoConcatenate
Temp:
load Date(Date#(Datenum,'YYMMDD'),'MM/DD/YY') as Date

inline [
Datenum
221031
];

Exit Script;