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)
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 (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 (BOB member since 2002-06-20)
Thank you so much. It works great!
John
jbradley (BOB member since 2007-10-22)