2 Replies Latest reply on Feb 28, 2011 1:20 AM by AlexPalmer

    Extracting part of a serial number to use in a calculation

    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