+ Start a Discussion
Bob_poliquinBob_poliquin 

Date formula display text if true

I am trying to create a formula that compares a date field Like Acme_Date__c = TODAY() then display "TODAY" for atext value. 

I'm not sure how to accomplish this result without getting errors 
Best Answer chosen by Bob_poliquin
Maharajan CMaharajan C
Hi Bob,

Try the below formula:

IF( Acme_Date__c = TODAY() , 'TODAY','')

Thanks,
Maharajan.C

All Answers

Bob_poliquinBob_poliquin
This is what I have so far that is causing errors
IF  (TEXT(Acme_Date__c = TODAY(), "TODAY")))
Maharajan CMaharajan C
Hi Bob,

Try the below formula:

IF( Acme_Date__c = TODAY() , 'TODAY','')

Thanks,
Maharajan.C
This was selected as the best answer
Bob_poliquinBob_poliquin
Thank you 
Maharajan!