I've this table below, And I need to calculate between two dates, the number of working day.
This table is like that I can't change it.
So mondayamid for monday morning mondaypmid for monday afternoon and so on...
Thus fields contain the id of the type of day, 1 for working day, 2 for holiday, 3 for sick. And there is the number of the week on a year.
Please I've no idea how to calculate the number of workday or half day between two dates.
THANKS SO MUCH
where owneridname like '%Julimian%'
So every half of day, I've the id of the type of the day that people took.
1 - working
View Complete Post