function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
BeerboyBeerboy 

Calculate "Age" of a Task

How can we calculate the "age" of a Task?

When creating a Task, our users fill in the standard object "Due Date" (field name is ActivityDate).

Unfortunately, Salesforce doesn't give us access to ActivityDate when creating a custom formula.

I could create a custom field to use instead of the standard field, but then the users lose the functionality of the "Overdue, Today, Tomorrow..." etc drop-down box in the "My Tasks" section on their home page.

I tried to do this creating a Workflow rule, but as with formulas, Salesforce doesn't provide access to the field ActivityDate to perform any type of operation.

Surely someone else has run into this problem and has a solution?

:smileyindifferent:
olkeitholkeith
Today() - CreatedDate
 
Would this help?
 
This should return how many days old this task is...
BeerboyBeerboy
Sorry, I guess I wasn't clear...I need to be able to calculate the age of the Task against the "Due Date".
olkeitholkeith

Interesting.  This should be reported as a bug.

 

I also noticed that i cannot access "Activity Type"