Academic Periods - Current, Future, Past Formulas
Current?
IF(TODAY() >= TargetX_Base__Start_Date__c && TODAY() <= TargetX_Base__End_Date__c,'Yes','No')
Future?
IF(TODAY() <= TargetX_Base__Start_Date__c && TODAY() <= TargetX_Base__End_Date__c,'Yes','No')
Past?
IF(TODAY() >= TargetX_Base__Start_Date__c && TODAY() >= TargetX_Base__End_Date__c,'Yes','No')