Trying again - calendar table

building reports desktopintelligence
12

Hi Dave,

When we did this we resolved the count of Monday to Friday days between two different date columns using SQL.

I posted it here:-

https://bobj-board.org/t/139422

then subtracted a seperate, simple, DB function to calculate the holidays to subtract.

We found this performed better than doing everything within a function, but that was using SQL Server.

When first thinking about this problem, you think you could use a holiday flag in your calendar which is fine if you are just looking at counting dates in the one column.

It gets trickier when you are trying to compare a start and an end date which are contained within different columns i.e going crossways rather than downwards :crazy_face: .

Thanks for the Oracle example though, I’ll store it with all my other “stuff”…:mrgreen:

Mak 1 :uk: (BOB member since 2005-01-06)