3 Replies Latest reply on Nov 6, 2015 8:18 AM by Fred(CH)

    Problem performing date comparisons in a script

    StefanZaryczny

      Version: FileMaker Advanced 12.0v5

       

      I'm trying to compare two dates in a script.  The problem is, whenever the two dates I'm comparing are in the same month the results are wrong. 

       

      For instance with red being the result....

      -------

      If 8/16/2015 > 8/15/2015

           True

      Else

           False

       

      The result is false when I step through the script even though the result should be True.

      -------


      However if I compare two dates in different months the result is as expected.


      If 11/16/2015 > 8/15/2015

           True

      Else

           False

      --------



        I've attached screen shots of the script debugger.  Has anyone else experienced this?