Use date-based wildcards to generalize reports

You can generalize a report by using wildcards instead of specific information when building certain reporting elements.

For example, if you want to create a report that shows the tasks that have a specific Planned Start Date, you can use the calendar date picker in a filter to select a specific date. However, if you want to create a report that shows tasks that have the Planned Start Date within a certain timeframe from the date when the report is accessed, you can use a wildcard that indicates that when someone views the report it displays information for a timeframe relevant for the moment when they view the report.

For example in the past week, in the past year, in the next two weeks, etc. This way, you build the report once, but because you use a wildcard in the filter, it produces different results every time someone reads it because it adapts to the day when they run the report.

You can use date-based wildcards when building the following reporting elements:

  • Filters
  • Custom prompts
  • Views when adding rules for columns

Access requirements

You must have the following access to perform the steps in this article:

Adobe Workfront plan*
Any
Adobe Workfront license*
Plan
Access level configurations*

Edit access to Filters, Views, Groupings

Edit access to Reports, Dashboards, Calendars to edit reporting elements in a report

Note: If you still don't have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.

Object permissions

Manage permissions to a report to edit reporting elements in a report

Manage permissions to a view or filter to edit them

For information on requesting additional access, see Request access to objects.

*To find out what plan, license type, or access you have, contact your Workfront administrator.

Prerequisites

You must create a report before you can add wildcard variables to it.

For information on creating a report, see Create a report.

How-to steps

To insert a date-based wildcard in a report:

  1. Go to a report for which you want to insert a date-based wildcard.

  2. Click Report Actions, then Edit.

  3. Click the Filters tab.

  4. Click Add a Filter Rule.

  5. Start typing the name of the field that you want to filter by.
    You must type fields that reference a date.

  6. Select Equal in the drop-down menu for the filter variable.

    note tip
    TIP
    You must always select the Equal filter variable when working with wildcards in Adobe Workfront.
  7. In the Start typing name … box, type: $$TODAY if you want to display information about something that occurs the same day that the report is run.

    Or

    Type $$NOW if you want to display information about something that occurs at the same date and time that the report is run.

    This date is always different, as it changes with the date the report is actually viewed by a user. so the information in the report is different from day to day.

  8. (Optional) If you want to display information that occurs within a timeframe after the date when the report is run, type $$TODAY+1w to display information in the following week, or $$TODAY+2m to display information in the next two months. You can also indicate timeframes for quarters, hours, days, or years.

  9. (Optional) If you want to display information about something that occurred within a timeframe before the date when the report is run, type $$TODAY-1w to display information from the previous week, or $$TODAY-2m to display information from the previous two months. You can also indicate timeframes for quarters, hours, days, or years.

    For a complete list of attributes, qualifiers, and operators that you can use in date-based wildcards, see the article Wildcard filter variables overview.

  10. Click Save + Close.

Additional information

See also:

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43