function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Bob_zBob_z 

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_z
Maharajan CMaharajan C
Hi Bob,

Try the below formula:

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

Thanks,
Maharajan.C

All Answers

Bob_zBob_z
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_zBob_z
Thank you 
Maharajan!