+ Start a Discussion

How do I made a custom activity field using ActivityDate

I have made some custom activity fields successfully, but I need help making new ones that have ActivityDate in them. I do not see Date, ActivityDate, or ActivityDateTime in the Insert Field choices. My attempts to write it myself result in syntax errors.


Examples of objective that won't work for me now that I need help with (in the Activity Object):


1. Basic: New label: just "ActivityDate" with new field name

2. Show missed activities: IF(AND(ActivityDate < TODAY(),Closed = FALSE), "Past Due", "Future")

3. Days to next activity: IF(Closed = FALSE, ActivityDate - TODAY(), NULL)


How can I modify the above to realize them using a custom activity field?

Steve :-/Steve :-/

ActivityDate can't be referenced by Formulas, it's a Dead End