Dates between start/end date

queue202 — Thu, 01 Sep 2022 00:31:22 GMT

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.

Re: Dates between start/end date

SunilChauhan — Thu, 01 Sep 2022 04:57:59 GMT

you query is not clear ? please share more info possibly sample data and required output?

topic Dates between start/end date in App Development

Dates between start/end date

Re: Dates between start/end date