Need to create an attribute that I can use in the system that can tell me if a tasks finish date is in the past.

Products

• Clarity PPM SaaS

Issue/Introduction

We have an attribute called "Is Late" that measures whether a task is late against the baseline (response Yes or check mark or No and the cell is blank). We would like to be able to add an attribute to the system that enables us to do this against the finish date vs the current date (today). 

Environment

Release : 15.8

Component : CA PPM SAAS PROJECT MANAGEMENT

Resolution

The Task Object has a stock field named 'Is Late' that provides similar functionality, refer to online documentation for stock reports that utilize this field.

• The 'Is Late' field will show a value when the Project has been baselined because it uses the baseline finish date to determine if the task is late 
• This field is available in both Classic and Modern UX for Projects 
• This field is available, but NOT populated for Custom Investment Types in Modern UX because CITs do not have the Baseline functionality 

To create a custom solution for the described outcome, follow the steps below:

1. Create custom date attribute on the Task object which will be updated by GEL script daily to hold current date 
2. Create custom calculated attribute which will hold a number and do datediff between today's attribute (using the Now() function) and Task Finish date 
3. Create 3rd attribute of boolean type which will determine if it is late or not by comparing if calculated attribute is below zero (0) or not 

Additional Information

• For more details on how to use the Now() function in a calculated field, refer to KB: Create a field using Today's Current Date