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.![julian day table.png julian day table.png](https://community.jmp.com/t5/image/serverpage/image-id/25447i73AA6BB1935599C8/image-size/large?v=v2&px=999)