topic Re: julian date in QlikView

julian date

lukaspuschner — Mon, 21 Jul 2014 10:13:12 GMT

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?

Re: julian date

ashfaq_haseeb — Mon, 21 Jul 2014 10:16:38 GMT

Hi,

Try below

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

Regards

ASHFAQ

Re: julian date

lukaspuschner — Mon, 21 Jul 2014 10:47:09 GMT

thank you, i m going to try it

Re: julian date

lukaspuschner — Mon, 21 Jul 2014 11:08:05 GMT

thanks again, but it is not working

Re: julian date

ashfaq_haseeb — Mon, 21 Jul 2014 11:11:03 GMT

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

Re: julian date

lukaspuschner — Mon, 21 Jul 2014 11:17:33 GMT

i ll try

Re: julian date

tresB — Mon, 21 Jul 2014 11:26:10 GMT

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

Re: julian date

lukaspuschner — Mon, 21 Jul 2014 11:33:46 GMT

it works perfect, thank you

Re: julian date

ashfaq_haseeb — Mon, 21 Jul 2014 11:35:12 GMT

My pleasure

Regards

ASHFAQ