Grouping: Projects by Entry Date

In this custom project grouping, you can display projects grouped by their Entry Date values.

Each grouping shows projects with an Entry Date within:

  • the last 30 days
  • 30-60 days
  • 60 days or older

To apply this grouping:

  1. Navigate to an existing Project report, or create a new Project report.
    For more information about creating a report, see "Creating a Report."
  2. From the Grouping tab, select New Grouping.
  3. Click Switch to Text Mode.
  4. Remove the text in the Group your Report area.
  5. Replace the text with the following code:
    group.0.linkedname=direct Entry
    group.0.valueexpression=IF(ABS(DATEDIFF({entryDate},$$TODAY))<=30,"Last 30 Days",IF(ABS(DATEDIFF({entryDate},$$TODAY))>30&&ABS(DATEDIFF({entryDate},$$TODAY))<=60,"30-60 Days","Older than 60 days"))
  6. Click Save + Close.
This article last updated on 2018-03-07 19:56:12 UTC