Follow
HOW TO: Group projects by entry date for 0-30, 30-60, 60+ days

Grouping projects by entry date

In this custom project grouping, you can display projects grouped by their entry date values.
The breakdowns show entry date for the last 30 days, 30-60 days, and 60 days or older.

Steps to add grouping

To apply this grouping:

  1. Navigate to an existing Project report, or create a new Project 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
    group.0.name=Project 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"))
    group.0.valueformat=atDateAsMonthString
    textmode=true

  6. Click Save + Close.