IF statements with dates and calculations (FP10)
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?