Date across month calculation

[ebiscaro]

Good Morning,

I have a table where I record period of time:
Example:

ID1 from 25-apr-06 to 06-may-06 Holiday
ID1 from 06-may-06 to 02-jun-06 Work

How do I automatically calculate how many days ID1 was on Holiday and how many days was workign in may?

Any help appreciated

Enrico

 

[namliam]

How many days on holidy would simply be date2 - date1 = number of calander days

If you want it in workdays you need a function to determain what are workdays and what are national holidays. I think there is a function floating around the forum (probably in one of the sample ones) that does that for.

 

[ebiscaro]

How many days on holidy would simply be date2 - date1 = number of calander days

If you want it in workdays you need a function to determain what are workdays and what are national holidays. I think there is a function floating around the forum (probably in one of the sample ones) that does that for.

Thank you,

Luckily I do not need to separate work days form week end or bank holiday. I would need to know how many days Holiday in May and how many in June similar for working day.
The problem is when my date record is across the month, then I need to separate the days between the different month.
Any idea?


Example:
From TO
25-may-06 05-jun-06 Holiday --> 7 days in may 5 days in June
28-Jun-06 07-jul-06 --> 3 days in June 7 in July

 

[namliam]

How would you want/need to split this? Do you want to have seperate colums for the month? It actually shouldnt be that hard...