Filtering Using a Range Based on Current Date

In Bullhorn Reporting, you can filter using a date range based on the current date.

For example, if you wanted to filter the date to within the last 7 days then follow the below steps.

The syntax to use in the advanced filter is:

Copy

X is the number of days you want to look within.

[...].[dateAdded] between _add_days(current_date,-X) and current_date

Steps

Select the Date Added column on your report.

Click on Filters and select Edit Filters....

Click Add, as represented by a plus sign, to add a new filter.

Select the Advanced option and click OK.

In the Expression Definition box, type in the following:

Copy

X is the number of days you want to look within.

[...].[dateAdded] between _add_days(current_date,-X) and current_date

Verify the Expression Definition by selecting Validate to check for errors. Correct if necessary.

Select OK

Now, you can go back to the main screen and RUN the report.