I have two fields in the database "Employee start date" and "Employee end date" How do I count all the employees that were employees on a given date

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Robert

Robert

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 744 Points 500 badge 2x thumb
One way would be to create a report with the following filter:

Set to "All"


Employee Start Date - On or before - <ask the user>

Employee End Date - On or after - <ask the user>
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb
Robert,

I was about to give that same answer.  :)  But I think that in your report, you need to have a filter on Employee End date which takes into account employees who have a null End date.  ie they are still active employees.

so the second filter would be
(indented)
where any of the following
     where end date is on or after <ask the user>
     where End date is equal to the date (blank)
Photo of Robert

Robert

  • 0 Points
That worked thank you