2 Replies Latest reply on Jul 20, 2015 9:06 AM by katlawrence

    Calculation Results Changed when I went from FMPA11 to FMPA14.

    katlawrence

      Title

      Calculation Results Changed when I went from FMPA11 to FMPA14.

      Post

      I am having a problem with some calculation coding.  The calculation worked in Filemake pro advanced 11 and it no-longer works in 14. 

      The calc pulls the 4 digit year, 2 digit month, and 2 digit day from a date field.  The date field is set up with leading 0's for the day and month, and no separators.  The caluclated results should read yyyymmdd.  The date field reads this way.  For example, todays date reads 20150720.

      The problem is that when I switched to FMPA 14, the calculation started adding slashes into the date, and not giving a 2 digit month value.  Here is the code I use for the calculation:

      Right (Sample_Date ; 4 ) & Left( Sample_Date ; 2 ) &  Middle (Sample_Date ; 3 ; 2 ) & Sample_Time & Sample_Source & Sample_Point_or_Material

      It used to give a nice 16 digit coded alpha numericvalue like 201507200800SOURCSMPT, now it is reading 20157/200800SORCSMPT.  Im at a loss here! Please help!

      Kat