Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Bree RuckriglBree Ruckrigl 

Trailhead Challenge: Receiving error, please help

I'm creating a formula field that determins the number of days between today and the last activity date for a case's account. I've created a Number formula of TODAY() - Last_Activity_Date__c. It's telling me the Challenge is not complete because "The 'Days_Since_Last_Update__c' formula field did not return the correct number of days between an Account’s Last Activity Date and today." 

Can someone help? Is my formula wrong?
Thanks in advance!
Pramodh KumarPramodh Kumar
Could you please try using this

if(Last_Activity_Date__c = today(),0,today()-Last_Activity_Date__c  )

Thanks,
pRAMODH
Bree RuckriglBree Ruckrigl
Tried it, didn't work :/
Shyama B SShyama B S
Hi Bree,
Please try using the below formula: 
Today()- Account.LastActivityDate

You need to use the Account's LastActivityDate field. Please let me know if this helped you.
Thanks
 
Pramodh KumarPramodh Kumar
is your
Last_Activity_Date__c == dateValue(LastModifiedDate)
Bree RuckriglBree Ruckrigl
I'm still getting the same error message. 
Bree RuckriglBree Ruckrigl
That helped! I made the Last Activity Date field a date instead of a Lookup. Thank you!!
Shyama B SShyama B S
Please check the below screenshot. I was able to complete it.
User-added image
Hope this helps.