LAST Activity (days)

Written By Daniel Beard

Days since contact

Use the code below to create a formula field on your Account object. Then you can add the field to your Account List and sort to see who you haven’t contacted in a while. See below for the YouTube video showing you how to make it work.

The Code

CASE(
max((BLANKVALUE( ActivityMetric.LastActivityDateTime , now()-36500) - now()),
(BLANKVALUE( ActivityMetric.LastCallDateTime , now()-36500) - now()),
(BLANKVALUE( ActivityMetric.LastEventDateTime , now()-36500) - now()),
(BLANKVALUE( LastModifiedDate , now()-36500) - now()),
(BLANKVALUE( ActivityMetric.LastEmailDateTime, now()-36500)- now())
)
, (BLANKVALUE(ActivityMetric.LastActivityDateTime, now()-36500)) - now(), TODAY() - DATEVALUE(ActivityMetric.LastActivityDateTime)
, (BLANKVALUE(ActivityMetric.LastCallDateTime, now()-36500)) - now(), TODAY() - DATEVALUE(ActivityMetric.LastCallDateTime)
, (BLANKVALUE(ActivityMetric.LastEventDateTime, now()-36500)) - now(), TODAY() - DATEVALUE(ActivityMetric.LastEventDateTime)
, (BLANKVALUE(LastModifiedDate, now()-36500)) - now(), TODAY() - DATEVALUE(LastModifiedDate)
, (BLANKVALUE(ActivityMetric.LastEmailDateTime, now()-36500)) - now(), TODAY()- DATEVALUE(ActivityMetric.LastEmailDateTime)
, 0
)

The video

Daniel Beard