cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Date range on calculated column

MechelleW
Explorer
0 Likes
186

We have a report request to calculate days worked within a period based on position entry date or hire date. We have added a calculated column with %As_of_date% on position entry date and now when running the report with a date range it doesn't calculate just the days worked within the period selected in the date range, it is giving the total days worked from start of position entry date to today and not as an example Jan 1st to Mar 31st and just giving those days worked within the period. We need to see how many days the employee worked within the period. Any suggestions on how we could get this working in Advanced reporting in EC and if it's even possible. 

Accepted Solutions (0)

Answers (0)