function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
William Terry 12William Terry 12 

Need help creating formula

I am have problems with the following
For easier reporting and filtering, create a new custom formula field on the standard account object which looks at the SLA Expiration Date field and returns true if the current date comes after it. Otherwise, it should return false.The account object should have a custom date field with the Field Label 'SLA Expiration Date' and Field Name of 'SLAExpirationDate'. The resulting API Name should be 'SLAExpirationDate__c'. On a Developer Edition, the 'SLA Expiration Date' field may already exist.
The new formula field should have the Field Label 'SLA Expired' and Field Name of 'SLA_Expired'. The resulting API Name should be 'SLA_Expired__c'.
The formula field should be of type 'Checkbox'.
The formula field should calculate its response based on the current date.
The formula field should return true if the SLA has expired, and false if it has not.Check Challenge
Any suggestions oh how to create this formula would be appreciated
Sagar PareekSagar Pareek
Create a new formula field with label  SLA_Expired with return type Check box.

The formula will be 
 
IF(TODAY()>SLAExpirationDate__c,true,false)

 
Swayam  AroraSwayam Arora
Create a new formula field with label  SLA_Expired with return type Check box.

The formula will be 

SLAExpirationDate__c < TODAY()


Please mark the answer as Best Answer if you find it useful.