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)? | Community
Skip to main content
Lila_Whitney
Lila_Whitney
Level 4
August 26, 2021
Question

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

  • August 26, 2021
  • 1 reply
  • 430 views
No text available
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
August 26, 2021

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

Terms & ConditionsAccessibility statement

Loading footer...