Hello, i am having issues with start and end date.
I have a table that includes start date and end date fields. I need to calculate total hours for each month that an employee has been employed (weekends included).
The issues im running into are the calculation isnt calculating partial months when an employee started or ended.
I also have another table that will need linked, but should just display the total hours the employee was employed that month + the remaining fields of that table (table2).
Ex:
table1 has startdate, enddate, ID
table2 has ID, location, pt/ft, updated_in_date
App should display
id, total hours, location, pt/ft, updated_date
But i need to use the updated_date to filter through start and end dates.
