julian date

[lukaspuschner]

Hello,

i have an problem with the julian date.

i have julian numbers like 2456811.

This number is the 02.06.2016 in our time.

Can someone explain me hot to calculate this in qlikview?

[ashfaq_haseeb]

Hi,

Try below

Date(MakeDate(1900+left(text(FIELDNAME),len(FIELDNAME)-3))+right(text(FIELDNAME),3)-1) as [Date],

Regards

ASHFAQ

[lukaspuschner]

thank you, i m going to try it

[lukaspuschner]

thanks again, but it is not working

[ashfaq_haseeb · Accepted solution]

Ah I see

That will work if you have 6 digit date. But you have 7 digit.

you need to subtract the offset 2415019 which is equivalent to 30.12.1899

try below

Load *,

Date(Date - 2415019) as NewDate;

Load * inline

[

Date

2456811

2455825

];

Regards

ASHFAQ

[lukaspuschner]

i ll try

[tresesco]

If your date 02.06.2016 -

is  in DD.MM.YYYY, then try

          Load

                   Date( YourJulianDateNum-2414288 ) as Date

if in MM.DD.YYYY, then

          load

                    Date( YourJulianDateNum-2414405 ) as Date

[lukaspuschner]

it works perfect, thank you

[ashfaq_haseeb]

My pleasure

Regards

ASHFAQ