I am having a hard time with the IF statement. I have a Status category I would like to make student status change based on Anticipated graduation date, however, I don’t have that for all students. So this is the formula I am trying and failing at:
You have to first test if there is an {Anticipated Graduation Date} before you make the other checks. You also have to use date/time functions for comparing dates.
Active Student: the {Anticipated Graduation Date} is after today
Graduated: the {Anticipated Graduation Date} is today or earlier