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.
Was this helpful?
No