calculating Working days ( excluding saturday and Sunday )

italugyaja

Hi guys,

I need to calculate the number of working days between two workorder.reportdate in maximo7 .

I need to display the difference b/w these two reportdates excluding saturdasy and sundays .

Now as we know that BIRT has an inbuilt function for the DateTimspan --days for the same.

but that does nt take into account the saturdays and sundays .

Can anyone provide me with either the exact SQL logic.
or if its possible by any functionality of BIRT kindly let me know

Any help will be greatly appreciated

Thanks
AJ

vanna

I'm using following solution.
- Create table _timeline (Date DAY, Bool WORKDAY)
- Generate time line (one record = one day), set WORKDAY = 1 for work days and 0 for SAT, SUN and bank holidays
- Then u can simply SUM over WORKDAYS between two dates