Extracting part of a serial number to use in a calculation
Hi, I have a field with a serial number;
The first 2 digits are the year 10=2010
The next 3 digits are the day number for that year 116th day.
I would like to create a field "manufactured on" that gets the those 5 digits and auto fills them into a normal date (day/month/year).
I'm fairly new to FM. I know I need a date calculation to display the date in day/month/year, but I have no idea how to extract the 5 digits and arrange them for the calculation.
Any advice would be greatly appreciated.