4 Replies Latest reply on Apr 18, 2013 6:49 AM by philmodjunk

    help with nested IF statement for FM12??

    HeidiStewart

      Title

      help with nested IF statement for FM12??

      Post

           I need help to write the equivelant of a nested IF statement for FileMaker Pro 12.

           here are my fields:

             
      •           Active (yes or no drop down)
      •      
      •           MSc Start Date (data enter date field)
      •      
      •           PhD Start Date (data enter date field)
      •      
      •           MSc End Date (calculation of MSc Start date + 2 years)
      •      
      •           MSc Ext End date (data enter date field)
      •      
      •           PhD End Date (calculation of PhD Start date + 4 years)
      •      
      •           PhD Ext End date (data enter date field)

           I want a report that shows only those students whose Active status = Yes

           then i need it to show the students upcoming end date.... here's where it gets complicated.

           some students have a start date in both the MSc Start Date and PhD Start Date fields. 

           So i need it to look in the PhD Start field, IF there is a date in there, then i need it to look in the PhD Ext End date field, IF there is a date in there, then it should show this date.

           If the PhD Ext End date field is empty then it should use the PhD End Date calculation field.

           IF there was no date in PhD Start Date field, then i should look in MSc Ext End date field, IF there is a date in there, it should show this date.

           IF the MSc Ext End date field is empty then it should use the MSc End Date calculation field.