topic How to convert Julian Date (YYDDD) to Calendar Date *ddMonyyyy"? in Discussions

How to convert Julian Date (YYDDD) to Calendar Date *ddMonyyyy"?

Alex19 — Thu, 12 Dec 2024 15:10:36 GMT

Hello community,

I think I exhausted all my options, even AI does not give me the correct answer.

I have a column with multiple Julian Dates - hundreds of them (e.g. 23233 etc.) and need to have a column with calendar date. Let's name Julian date column as "Julian Date".

Either formula in the column or a script would be good!

Thank you ALL!

Alex.

Re: How to convert Julian Date (YYDDD) to Calendar Date *ddMonyyyy"?

txnelson — Thu, 12 Dec 2024 16:07:17 GMT

Here is my way of handing this

Names Default To Here( 1 );
dt = New Table( "Example",
	add rows( 10 ),
	New Column( "Julian Date",
		set each value(
			Num(
				Char( Random Integer( 20, 24 ) ) || Char( Random Integer( 100, 365 ) )
			)
		)
	)
);

// Create a column that converts Julian dates to JMP date values
dt << New Column( "Date",
	Format( "m/d/y" ),
	formula(
		Date MDY( 1, 1, Num( Substr( Char( :Julian Date ), 1, 2 ) ) )
		+In Days( Num( Substr( Char( :Julian Date ), 3, 3 ) ) )
	)
);

Re: How to convert Julian Date (YYDDD) to Calendar Date *ddMonyyyy"?

Alex19 — Thu, 12 Dec 2024 16:09:58 GMT

Works very well! Thank you Jim!!

Alex.