Skip to main content

Return to TX Community

Liaison

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')

 

  • Was this article helpful?