Convert today's date to Julian format

[monish_chandra]

How can we convert DateTimeToday() i.e 02/06/2018 to Julian format i.e 19037? Is there a function/Tool in Alteryx? I'm quite new to Alteryx. Just curious to know does Alteryx use .net functions in the backend?

[cmcclellan]

This is what you're after ... 

ToNumber(DateTimeFormat(DateTimeToday(), "%j"))

[monish_chandra]

Woah! that looks so simple, thank you so much! 

Current Date: 02/06/2019

Expected Julian Date: 19037

%j gives 37. How to get 190 which I believe is the month and the year in Julian format

[cmcclellan · Accepted solution]

Oops, sorry I forgot about the year component:

Substring(DateTimeNow(),2,2)+
DateTimeFormat(DateTimeToday(), "%j")

I was cheating a bit and changing back to a number.  If I keep it as string and then add a year to the start :)