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
David MeatsDavid Meats 

Keep getting an error with "Introduction to Formula Fields" module??

I am a newbie....
I keep getting the error message:
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

This is the formula I am using as there is no Last Activity Date field in the case object. 
SO I am using Lastmodified Date field from the Case object.
ABS( DATEVALUE( LastModifiedDate ) - TODAY())
Which returns a value of "11" as number when I view it in the report
Can someone please explain what I am doing wrong?? OR where do you find the "Last Acivity Date" field
Best Answer chosen by David Meats
AG_SFDCAG_SFDC
Hi,

Try This:
  
TODAY() - Account.LastActivityDate

Let me know if it helped you!

Thanks,
AG
 

All Answers

Dianna Raquel Perez GüerequeDianna Raquel Perez Güereque
What happens if you just use:
"TODAY() - DATEVALUE( LastModifiedDate )" ?
David MeatsDavid Meats
Thanks Dianna for taking the time to post your formula.  I just tried it and still no success and getting the same error..
AG_SFDCAG_SFDC
Hi,

Try This:
  
TODAY() - Account.LastActivityDate

Let me know if it helped you!

Thanks,
AG
 
This was selected as the best answer
David MeatsDavid Meats
Thanks AG,

That worked .... I would have looked the account object but it said you had to use the case object.  Thanks again