Hi,
can anyone please help me on this business days calculation, the information as follows:
1) i calculated the no of working days between two days (excludinf weekends)-- this result is fine.
2) From this result we have to exclude the company holidays within that dates range, if any? For company holidays we have seperate table, we have to check no of holidays between the date range.
3) i tried by creating hotfile and also by joining based on dates (in catlog) for that holidates, but the other data is adding up if there are more than one holiday between those dates range.
Thanks.
can anyone please help me on this business days calculation, the information as follows:
1) i calculated the no of working days between two days (excludinf weekends)-- this result is fine.
2) From this result we have to exclude the company holidays within that dates range, if any? For company holidays we have seperate table, we have to check no of holidays between the date range.
3) i tried by creating hotfile and also by joining based on dates (in catlog) for that holidates, but the other data is adding up if there are more than one holiday between those dates range.
Thanks.