Formula to Convert Calendar Date to Julian Date

Alex19

Hi All, I need a formula to convert Calendar Date (column is in Character/Nominal Type, dd/mm/YYYY format) to Julian Date (numeric). For example, in Row#1 from 07-Mar-2024 (07/03/2024) to 24067:

Thank you!

Alex.

 

 

jthi

Local(
	{date = InFormat(:Calendar Date, "Format Pattern", "<DD>/<MM>/<YYYY>")},
	Num(Right(:Calendar Date, 2) || Right("00000" || Char(Day Of Year(date)), 4))
);