Formatting from number to date bug

[holymosfet]

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.

Thank you!

[Or · Accepted solution]

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

[holymosfet]

Whoop! Fixed it. Thank you 😊

[sidhiq91]

@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;