+ Start a Discussion
Elmer UytingcoElmer Uytingco 

Stuck on "Using Formula Fields" Trailhead Training

Getting the following Error:

Challenge not yet complete... here's what's wrong:
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
Squire Q KershnerSquire Q Kershner
Some details about what you've tried (cut/paste your formula) will help us to help you.
Elmer UytingcoElmer Uytingco
I just found the answer, here is what I did; looks like I needed to add the parenthesis.

(TODAY()- Account.LastActivityDate)

Thanks for the quick response :-).
Elmer UytingcoElmer Uytingco
Do not understand why I needed to add parenthesis?
Amit Chaudhary 8Amit Chaudhary 8
Please try below formual. Please create one formula field with Number type on case object like below 
(Today()- Account.LastActivityDate)
Same worked for me

Pleas elet us know if this will help u

Thanks,
 
Matt Goulding 1Matt Goulding 1
Tried this today, but getting error message: "Field Account does not exist. Check spelling".
I am in the case object, but it will not recognise any account fields. In the Select Field Type box I only have $Organisation, $User Role, $System, $Profile, $User and no standard objects like Account.
User-added image
Any help appreciated!!