3 Replies Latest reply on Dec 15, 2015 12:44 PM by ralvy

    Text function RIGHT on FM Server 14 v4 reports incorrect value

    ralvy

      I have a small database hosted at FMPHost.com and notice the following oddity when using the Right function on a text string:

       

      Right ( "0001" ; 3 ) in FMPA 14 v4 Client (Mac) correctly returns "001". But FMS 14 v4 Server (Windows) returns "01".

       

      Right ( "0001" ; 4 ) in FMPA 14 v4 Client (Mac) correctly returns "0001". But FMS 14 v4 Server (Windows) returns "001".

       

      FMPHost says they're running FMS 14 v4 on Windows Server 2008 R2 machines.