Last post Dec 18, 2014 09:36 PM by Edwin Guru Singh
Dec 18, 2014 12:25 AM|gani7787|LINK
I am struggling with the query.
i have below record to query to calculate the employee working days from date of joining.
i want query that calculates the no.of working days,public holidays and it should calculate from date of joining.
because the public holidays will get reduced it it may vary for every employee while we taking from Date of joining
how to form a query..?
Dec 18, 2014 09:36 PM|Edwin Guru Singh|LINK
I got an idea about your query. But I can't well understand about your table structure.
If you don't mind,Can you re-post here your real table structure with values & your expected output structure with values ?
Because its more helpful us to find the exact solution.