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)?

[Doug_Den_Hoed__AtAppStore]

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