Post

2 followers Follow
0
Avatar

Compare Due Dates for 2 different tasks on a project?

Hi,

I need to compare the due date of a task with the due date of another task.  How can I create a Formula Field to show the date difference in days?  One task has a milestone number of 4.08 and the other 4.09.  Is there a way to compare the two task dates in a Formula Field?

Thanks,

Karen

Karen Hopson

Please sign in to leave a comment.

1 comment

0
Avatar

Hello Karen,

I think this is technically feasible, but it will be a complicated solution. A custom field can't do it since custom fields can only access the current object's data and not the data of other objects. The implementation will depend on your exact requirements — I recommend working with your PS consultant on this.

Thank you,

Roland

Roland Pumputis 0 votes
Comment actions Permalink