Troouble coverting date in YYYMM format to DD/MM/YYYY qliksense

[Aspiring_Developer]

@sunny_talwar 

Hello Everyone,

I have below [SOP Month/Year] field in raw data. I am trying to create Date using this . i tried below :-

Date#(Date("SOP Month/Year",'YYYYMM'),'DDMMYYYY') as Date,- didn't worked. it gives below output:-

I tried using other functions like num , floor, makedate , etc but it didnot worked

MakeDate("SOP Month/Year",1) as New_Date,

Please help

Thanks is advance

[sunny_talwar · Accepted solution]

Try this instead

Date(Date#("SOP Month/Year", 'YYYYMM'), 'DDMMYYYY') as Date