Forum Discussion

Vantage111's avatar
Vantage111
Frequent Visitor
3 years ago

Summarizing Employee Numbers by date

I have a table that has an employee ID, a date when they joined the company (join_date) and a date when they left the company (leaving_date). An employee is still a member until the leving_date is no...
Need Help
AlexisOlson's avatar
AlexisOlson
Super User
3 years ago

Try [Date] instead of Date.

  • Vantage111's avatar
    Vantage111
    Frequent Visitor
    3 years ago

    Alexis

    Thank you, I had spotted the error and also another two that I will put below for completeness.

    Changed the MAX(Employee[join_date]) as in the previous version anyone joining after the last leaver would not register.

    Also added the OR employee[leaving_date] = Blank() to include those employees that have not left.