AnsweredAssumed Answered

IF statements with dates and calculations (FP10)

Question asked by need2know on Aug 26, 2009
Latest reply on Aug 27, 2009 by comment_1

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? 

Outcomes