Business days between

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)

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)

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)

Try:

or


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

Thank you so much. It works great!

John


jbradley (BOB member since 2007-10-22)