Look up Case in FileMaker help.
Case ( Not IsEmpty ( PhD Ext End date ) ; PhD Ext End ;
Not IsEmpty ( PhD End Date ) ; PhD End Date ;
Not IsEmpty ( Msc Ext End Date ) ; Msc Ext End Date ;
Not IsEmpty ( Msc End Date ) ; Msc End Date )
It's even possible that this function will do the trick:
Max ( PhD Ext End ; PhD End Date ; Msc Ext End Date ; Msc End Date )
ok the case not isempty didn't work, but the Max one did! you rock thanks!
The case function should have worked. I'm concerned that it didn't.