Convert julian code into BBD shef life of product

[#1]

I have recieve some san remo product with julian code and Im trying to convert into year, months and days to find out their shelf life.

Please can some help me to find:

1. L4032 S2 = 

2. L4054 L4 = 

[#2 · Accepted solution]

I am not aware of any Julian date like these.  If you know how to interpret them, I am sure I can provide you with how to calculate them in JMP.

If by chance the first digit is the year, and the last 3 digits is the days in the year then 

names default to here(1);
code ="L4032 S2";
Year = 2020 + num(substr(code,2,1));
date =  datemdy(1,1,year) + Indays(num(substr(code,3,3)));
show(format(date,"m/d/y"));

would show

Format(date, "m/d/y") = "02/02/2024";

[#3 · Accepted solution]

Thanks Jim,

So the date is 02/02/2024, meaning the product has passed its Best Before Date.