Date conversion in SQL and QlikView

raju_salmon — Wed, 01 Aug 2018 21:45:12 GMT

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

Re: Date conversion in SQL and QlikView

vishsaggi — Wed, 01 Aug 2018 21:49:48 GMT

Are you looking for this?

raju_salmon — Wed, 01 Aug 2018 22:03:18 GMT

Thanks Vishwa. Solved my issue.