AnsweredAssumed Answered

Extracting part of a serial number to use in a calculation

Question asked by AlexPalmer on Feb 27, 2011
Latest reply on Feb 28, 2011 by AlexPalmer

Title

Extracting part of a serial number to use in a calculation

Post

Hi, I have a field with a serial number;

101160342A

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.

Many thanks 

Outcomes