topic Re: Convert julian code into BBD shef life of product in Discussions

Convert julian code into BBD shef life of product

SampleModeMouse — Fri, 30 Aug 2024 00:53:23 GMT

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 =

Re: Convert julian code into BBD shef life of product

txnelson — Fri, 30 Aug 2024 02:04:36 GMT

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";

Re: Convert julian code into BBD shef life of product

SampleModeMouse — Fri, 30 Aug 2024 03:56:34 GMT

Thanks Jim,

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