5 Replies Latest reply on Aug 27, 2009 2:20 PM by comment_1

    IF statements with dates and calculations (FP10)

    need2know

      Title

      IF statements with dates and calculations (FP10)

      Post

      I have a calculation field with the following:

       

      If (M Date To ≤ 31/8/2009;Total kms * .62;Total kms * .7)

       

      The first part of the If statement is not happening - and is only calculating the second part, regardless of the date.

       

      I have tried this one also - 

      If (M Date To ≤ 31/8/2009;Total kms * .62; If (M Date To  ≥ 1/9/2009;Total kms * .7))

       

      I can't seem to get it to work. Can anyone help?