Hi Expert,
I have a reference SQL code to create a field called Project date using existing field.
Set Conc = '||'
Select *,
Date('01/01/' $(Conc) char(int(field1/1000)+1900))+(field1-int(field1/1000)*1000-1) days as ProjectDate
From table;
Note: field1 contains 6 digit data.
I need to create this field in Qlik, i have tried but not getting desired result. Can any SQL and Qlik expert would help me here.
Tried below one but did not work.
Load *,
Date(('01/01/' & text(num(field1/1000)+1900))+(field1-num(field1/1000)*1000-1),'YYYY/MM/DD' as ProjectDate
Thank you
