need help

[saraswati]

Please help me accomplish the following requirement in FileMaker Pro.

I have 5 fields each with values YES & NO

1. UM Fee Waiver

2. FS Scholarship

3. Fin Aid Student

4. DANTES

5. VA

I have another field called Enrollment Date which is a date field.

I have to define a new field called FA Semester. The value of the FA Semester field is based on the following conditions.

If (UM Fee Waiver = "YES" or FS Scholarship = "YES" or FinAidStudent = "YES" or DANTES = "YES" or VA = "YES" ) {

if (Enrollment Date is between Sept 21 through Feb 20)

FA Semester = SPRING

else if (Enrollment Date is between Feb 21 through May 10)

FA Semester = SUMMER

else if (Enrollment Date is between May 11 through Sept 20)

FA Semester = FALL

}

[jasonwood]

Here is how the If statement works in a calculation:

If(condition, result if true, result if false)

You can nest if statements within eachother, or in this case, it'd be easier to nest a case statement within the If statement.

The case statement works like this:

Case(condition, result if true, another condition, result if true, another condition, result if true, default result)

The case statement stops after the first true condition.

Your condition for each date range would look something like:

Enrollment Date > Date(9,21,currentYear) AND Enrollment Date < Date(2,20,currentYear +1)

In this example, you would have to have a field called "currentYear"... there's probably a better way... I'm not very experienced with date functions.