Expand my Community achievements bar.

Interested in applying to or sharing a Workfront-related job opportunity? Check out the Workfront Job Board!

Is it possible to use a custom calculated field to return as a date +/- days from another date field? Or even +/- the Planned Completion/Start Date(s)?

Avatar

Level 4
 
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 10

Hi Lila,

Yes, you can, using DATEDIFF, WEEKDAYDIFF, WORKMINUTESDIFF (see here for details), but since by nature such date calculations tend to get stale over time, you might also instead consider a dynamic grouping, such as this:

group.0.valueexpression=IF(DATEDIFF({actualCompletionDate},{actualStartDate})<2,"0-2",IF(DATEDIFF({actualCompletionDate},{actualStartDate})<5,"3-5",IF(DATEDIFF({actualCompletionDate},{actualStartDate})<10, "6-10","10+")))

Regards,

Doug

page footer