calculated field using dates

[lmm1219]

Help! I am a beginner and need some help with a formula. Any help would be much appreciated.

I am trying to use a calculated field in my form using information from 2 other fields. The two fields are: ActualFrom(Date field), Miles(Numeric field), and the name of the calculated field is Mileage Charge.

I am trying to make an expression if Actual From is <7/01/02 than Miles *.30 or if Actual From is >07/01/02 than Miles *.32. Can this be done?

Anybody have any suggestions?

 

[Adrianna]

IIF(([Actual Form]<7/01/02),Miles *.30,IIF(([Actual From]>07/01/02,Miles *.32,"")))

Okay...I haven't tested it...but this should be close enough

Syntax

IIF((Condition),THEN, ELSE)