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
Marc Bowen 4Marc Bowen 4 

formula for before date and after date - text output

Hi All,

I have a date field (eg. 02/06/2021), it will be a future date as it calculates expected delivery date.

I would like to create a field that if today date is less than the expected date the field will display "Not Late", if today date is past/more than the expected date then the field must display "Late"

Please can you let me know if this is possible??

Thanks for the help!
​​​​​​​
Best Answer chosen by Marc Bowen 4
AbhinavAbhinav (Salesforce Developers) 
Hi Marc,

Yes you can create a formula field with return type text.

IF( ExpectedDeliveryDate__c >= TODAY() , "Not Late", "Late")

If It helps, Please mark it as best answer.

Thanks!

All Answers

AbhinavAbhinav (Salesforce Developers) 
Hi Marc,

Yes you can create a formula field with return type text.

IF( ExpectedDeliveryDate__c >= TODAY() , "Not Late", "Late")

If It helps, Please mark it as best answer.

Thanks!
This was selected as the best answer
CharuDuttCharuDutt
Hii Marc Bowen
Try Below Formula 
 Formula Field Data Type Text 

IF( DateField >= TODAY() , 'Not Late ','Late'))


Please Mark It As Best Answer If It Helps
Thank You!
Suraj Tripathi 47Suraj Tripathi 47

Hi Marc,

Please find the solution.

if(ExpectedDate__c > TODAY(),"Not Late","Late")
Thank You