Jun 09, 2016 07:31 AM
Did I miss something? It was working until I tried to add two IS_BEFORE together
IF(IS_BEFORE({End Date},TODAY()) + (IS_BEFORE({Start Date}, TODAY()) > 1, “Upcoming Class”,“Previous Class”)
Jun 09, 2016 10:29 AM
Fixed it:
IF(IS_BEFORE({Start Date}, TODAY()) > 0, IF(IS_BEFORE({End Date}, TODAY()) > 0, “Previous Class”,“Current Class”),“Upcoming Class”)