AnsweredAssumed Answered

Custom function or calculation

Question asked by filemakernew on Oct 26, 2012
Latest reply on Nov 8, 2013 by filemakernew


Custom function or calculation


     Hello all,

     kindly help me make a custom function or calculation that generates a Product Lot Number base on the last two Digit of a Year for the first two digits, the second two digits the number of the month and the last three digits are sequential of three digits starting with 001 base from the number of materials received from that month. below is an example.


     First two digits (06) - Year

     2nd two digits (09) - Month

     3rd 3 digits (001) - number of material arrived from that particular month

     Thank you.