Date conversion in SQL and QlikView

[raju_salmon]

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

[vishsaggi · Accepted solution]

Are you looking for this?

Oracle Julian Date Conversion

[raju_salmon]

Thanks Vishwa. Solved my issue.