You need to sign in to do that
Don't have an account?
Beerboy
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:
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:
Interesting. This should be reported as a bug.
I also noticed that i cannot access "Activity Type"