Business days between

building reports desktopintelligence
1

Is there a way to retrieve the number of business days (M-F) rather than just the DaysBetween()?

Thanks in advance

John

jbradley (BOB member since 2007-10-22)

2

Not really, as every company might define their business days differently (think company holidays). If you only wanted to exclude weekends, try a search on BOB, please (suggested keywords: business days weekends).

Otherwise this logic belongs in a data mart with a smart calendar table, which includes an additional column indicating if a date is a business day or not.

Andreas :de: (BOB member since 2002-06-20)

3

I do want to only exclude weekends. I have tried the searches of business days, week days, weekends etc to no avail. Just hoping for a solution.

Thanks

jbradley (BOB member since 2007-10-22)

4

Try:

or

Andreas :de: (BOB member since 2002-06-20)

5

Thank you so much. It works great!

John

jbradley (BOB member since 2007-10-22)