Establishing How Many Days Have Passed Since Date Added

In Bullhorn Reporting, there may be a need for you to have a column that calculates how long it’s been since an event occurred. For instance, how many days it’s been since a job was added.

Assuming you have a list report that includes Date Added as a column, you can follow the below directions.

Steps

1. From the Source tab, drag and drop another Date Added column next to the first. You can also right click the Date Added and select Insert if you have the desired chart selected.
2. Double-click the Date Added 1 column header.
3. In the Name field, modify the name. We used Days Active as an example
4. In the Expression Definition box, replace the contents with the below expression:​
   
   Copy

   _days_between(current_date,[PRESENTATION VIEW - JOB ANALYSIS].[JOB].[dateAdded])

   
   
5. Verify the expression for errors by selecting the check mark above the Expression Definition text box. Correct any errors.
6. Click OK and run your report.