Convert date (DD/MM/YYYY) into JDE julian dates

[hopkinsc]

Hi all,

What code do i need to use to convert a date into a julian date format?

[sujana1621]

Hi,

Can you tell us with an example.

[rwunderlich · Accepted solution]

=div(Year(today()),1000)-1
& num(mod(Year(today()),100),'00')
& num(today() - YearStart(today()),'000')

Replace "today()" with your date field. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com