Hello,
I am looking to create a lot counter in function of the experiation date of a product which we will reception from a purshace receipt.
For exemple if we enter the expiration date of July 1st 2023 and the product has a shelf life of 6 months , the lot number should be in related to Jan 1st 2023,
Follow this logic I then want my lot number to be expressed as L202C001A
L being a constant
202 = first 3 numbers of the year
C = 3 ( a=1,b=2,c=3, .... j=0)
001 = julian date
A being a constants
How would i go about this in ordre to get the date of Jan 1st 2023
I know the lot counter in fuction of today's date would be
Constant Lenght = 1 Formula = L
Formula Lenght = 3 Formula = mid$(num$(year(date$)),1,3)
Formula Lenght = 1 Formula = func SPEANM.GETLET(date$)
Formula Lenght = 3 Formula = func right$(num$("1000" + num$(date$-gdat$(31,12,year(date$())-1))),5)
Constant Lenght = 1 Formula = A
But i would need to apply this logic to Jan 1st 2023
Thank you