Converting a Julian Day into Month-Day

jay_holavarri — Fri, 09 Jun 2023 23:32:22 GMT

I receive material from a supplier that uses an encoded date in their material lot, which I'd like to convert to a regular date. It first encodes the three digit Julian date into a two-digit Base 36 hex, which I have found JMP can easily handle.

But converting the Julian date to month-day has been surprisingly elusive. There isn't a mention of Julian conversion I can find. Seems like I should be able to divide the JMP time by the number of seconds in a day or something.

I suspect someone here will know an easy solution.

Thank you.

Attaching the Julian look up table I was given.

Re: Converting a Julian Day into Month-Day

Jeff_Perkinson — Fri, 17 Jul 2020 18:54:49 GMT

Check out the In Days() function. It will take your Julian date as an argument and return the number of seconds in that number of days.

You can add that result (minus 1) to January 1 of the year in question.

jdate=239;

year=1998;

date= datemdy(01, 01, year)+(in days(jdate)-1);

format(date, "mm/dd/yyyy");

You might find helpful.

topic Converting a Julian Day into Month-Day in Discussions

Converting a Julian Day into Month-Day

Re: Converting a Julian Day into Month-Day