Filter reports by timeframes

Last update: Sun Oct 12 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

Topics:
Reports and Dashboards

CREATED FOR:

User

You can filter a report by the timeframe of a date that exists on an object. For example, you can filter an hour report for a particular timeframe of when the hours were entered.

Access requirements

Expand to view access requirements for the functionality in this article.

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
Adobe Workfront package	Any
Adobe Workfront license	Standard Plan
Access level configurations	Edit access to Reports, Dashboards, Calendars Edit access to Filters, Views, Groupings
Object permissions	Manage permissions to a report

For more detail about the information in this table, see Access requirements in Workfront documentation.

Prerequisites

The report must be created before you can filter its results.

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

Filter a report by the timeframe of a date filter-a-report-by-the-timeframe-of-a-date

Click the Main Menu icon in the upper-right corner of Adobe Workfront, or (if available), click the Main Menu icon in the upper-left corner, then click Reports.
In the top-left corner, click New Report, then select the type of report you want to create.
On the New Report page, select the Filters tab.
Click Add a Filter Rule, then Select a field.
In the Select a field dialog box, select Hour, then Entry Date.

In the drop-down that appears, select one of the following options:

table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 8-row-2 layout-auto html-authored no-header
Equal (Case Sensitive)	After selecting this modifier, specify the date when the hours were entered.
Not Equal (Case Sensitive)	After selecting this modifier, specify the date when the hours were entered to exclude this date from your report. The report shows hours logged in all dates, expect for the date you specified.
Less Than	After selecting this modifier, specify a date before which the hours were entered. The report shows hours entered before the specified date, not including the specified date.
Less Than Equal	After selecting this modifier, specify a date before which the hours were entered. The report shows hours entered before the specified date, including the specified date.
Greater Than	After selecting this modifier, specify a date after which the hours were entered. The report shows hours entered after the specified date, not including the specified date.
Greater Than Equal	After selecting this modifier, specify a date after which the hours were entered. The report shows hours entered after the specified date, including the specified date.
Between	After selecting this modifier, specify a date range when the hours were entered. The report shows hours entered between the specified dates.
Null	Select this modifier to display only hours where the Entry Date is missing.
Not Null	Select this modifier to display only hours where the Entry Date has a value.

Click Save + Close.

Built-in timeframe modifiers built-in-timeframe-modifiers

Adobe Workfront has built-in timeframe modifiers that you can use without defining a specific date. These modifiers are available for any date field in a filter or a prompt in any report.

For example, if you are building an hour report and would like to display hours entered in a specific timeframe, you can choose from the following built-in timeframe filter options:

Today

Displays hours where the Entry Date is today.

This Week

Displays hours where the Entry Date is a date in the current week, where the week starts on a Sunday and ends on a Saturday.

Next Week

Displays hours where the Entry Date is a date in the week following the current week, where the week starts on a Sunday and ends on a Saturday.

Last Week

Displays hours where the Entry Date is a date in the week prior to the current week, where the week starts on a Sunday and ends on a Saturday.

This Month

Displays hours where the Entry Date is a date in the current month.

Next Month

Displays hours where the Entry Date is a date in the month following the current month.

Last Month

Displays hours where the Entry Date is a date in the month preceding the current month

This Quarter

Displays hours where the Entry Date is a date in the current quarter, where quarters are defined as:

First Quarter: January 1 - March 30
Second Quarter: April 1 - June 30
Third Quarter: July 1 - September 30
Fourth Quarter: October 1 - December 31

Next Quarter

Displays hours where the Entry Date is a date in the quarter following the current quarter, where quarters are defined above.

Last Quarter

Displays hours where the Entry Date is a date in the quarter preceding the current quarter, where quarters are defined above.

Note: If your Workfront administrator has enabled and defined custom quarters for your system, the built-in filters for quarters are replaced with your custom quarter information. For more information about enabling custom quarters, see Enable custom quarters.

This Year

Displays hours where the Entry Date is a date in the current year, where the current year starts on January 1 and ends on December 31.

Past Year

Displays hours where the Entry Date is a date in the past year, where the past year starts 12 months prior to the current date.

Last Year

Displays hours where the Entry Date is a date in the last year, where the last year starts on January 1 and ends on December 31 of the year preceding the current year.

Note: There is no built-in time period for fiscal year. You can create a report and filter the information by date using a custom modifier for the date range of the fiscal year, as it is defined in your organization. If you want to choose a timeframe for a fiscal year on the spot, then you should use a prompt instead of a filter.

recommendation-more-help

5f00cc6b-2202-40d6-bcd0-3ee0c2316b43