I'm doing exercises on salesforce trailhead and created simple custom field of type Formula:

  • field is created on Case object
  • Formula Return Type: Number
  • Decimal Places: 0
  • Formula itself: TODAY() - Account.LastActivityDate
  • Blank Field Handling: Treat blank fields as zeroes

This should give me number of days since last activity on account. On case page I see the field, but it shows me blank value.

Is it a bug or I'm doing something wrong?

I'm on developer edition.


You probably getting it blank because there are no Activity records on related Account. Could you please check if any activity is present on the related account?

For difference in Last Modified Date and Last Activity Date, check this link:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.