+ Start a Discussion
Cynthia RyanCynthia Ryan 

formula challenge for day since last activity

I am working on one of the formula trailheads to create a formula field that determines the number of days between today and the last activity date for a case's account.  I think the data is incorrect on the challenge.  The challenge shows to use the last activity date for the case's account but when viewing that field on a report it does not show a date; it only shows a dash.  Even though it is a date field.  This is why my formula is not returning the number of days.  
Does anyone know how to correct the data?  I've already tried opening and changing some cases hoping it would trigger a date change but that didn't work.
DeepthiDeepthi (Salesforce Developers) 
Hi Cynthla,

Please use the below formula: 
(Today()- Account.LastActivityDate)

For more details, please check the below posts:
https://developer.salesforce.com/forums/?id=906F0000000DEamIAG 
https://developer.salesforce.com/forums/?id=906F0000000BMfxIAG

Hope this helps you!
Thanks,
Deepthi

 
Cynthia RyanCynthia Ryan
Thank you; that did the trick.  Would you happen to know about editing the Home Page?  I have the system administrator assigned as my profile that has customize application but I still can't edit the home page.  I'm sure it is something I'm doing wrong.
DeepthiDeepthi (Salesforce Developers)