Lot code calculation
I have a bit of a curly one (at least it is for me!)
I want to automatically generate a "Lot code" in a field that is based on the date.
Basically the format would be as follows:
L = Lot code No
13 = Year
243 = Day of the year
Any ideas would be MOST appreciated.