+ Start a Discussion
James CuretonJames Cureton 

Formula Fields Error LUVRAIPP

Hello,

I'm trying to complete the "Using Formula Fields" section in trailhead.
The task is:

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.


My syntax is: SLA_Expiration_Date__c < Today()

The error message I am receiving is: 
Challenge not yet complete... here's what's wrong: 
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: LUVRAIPP


Any help is appreciated.
 
SonamSonam (Salesforce Developers) 
Which ORG are you using to implement this formula? Not sure why the error message is prompting you to get a developer ORG..can you please share your ORG ID with me at sraju @ salesforce dot com
James CuretonJames Cureton
Yes. DE Org Id: Cureton.james@gmail.com
Sai Ram ASai Ram A
Hi James

to fetch ordId Go to Setup> Company Profile> Company Information> Salesforce.com Organization ID (18 digit)

Thank you
BLearn
 
SonamSonam (Salesforce Developers) 
Hey James, thanks for the user ID, I went through your ORG and checked the formula you have created. It looks correct and is working in my ORG when I replicated it.

Is it not working in your ORG?
James CuretonJames Cureton
It accepts that syntax as if it is correct in my ORG. When I try to submit it into trailhead though, it doesn't like it for some reason...
joshbirkjoshbirk
The challenge notes:

The resulting API Name should be 'SLAExpirationDate__c'. On a Developer Edition, the 'SLA Expiration Date' field may already exist.

But your field refers to:

SLA_Expiration_Date__c

With different underscoring.  Did the SLA Expiration Date not exist on your org?  If not and you need to create another one - be sure the final API name is SLAExpirationDate__c.
SFDC 2017SFDC 2017
@James Cureton.Try This.IF(SLAExpirationDate__c < TODAY(),true,false).