Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try using YYMMDD rather than yymmdd (uppercase, not lowercase). Lowercase 'm' is for minutes.
Try using YYMMDD rather than yymmdd (uppercase, not lowercase). Lowercase 'm' is for minutes.
Whoop! Fixed it. Thank you 😊
@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;