Link to home
Create AccountLog in
Avatar of Gary Chalmers
Gary Chalmers

asked on

How to calculate days worked from start date

I am trying to write a query to work out the number of days my employees have worked since they started at the company and for the report have a column named DaysEmployed.

Any help would be greatly appreciated.
Avatar of GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Do you want to work from a rule, such as counting all the days, subtracting weekends and bank holidays, or do you have attendance records in your database?
Avatar of Gary Chalmers
Gary Chalmers


Hi Graham. No requirement to subtract weekends and bank holidays. it is literally just to have a list of the employees and number of days the have been with the company
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks Fabrice