February 28, 2005, 06:50 PM
jimboBusiness Days Calculation
I have some simple date calcs in a define but need to show both in calendar & business days. Has anyone done business day calculations?
February 28, 2005, 07:06 PM
Leo LNot sure exactly what your doing in your calculations but if you were adding using DATEADD
then it would be
DATEADD(DATE1, 'BD', 1);
BD represents business day which can be configured by using the SET method.
To see what are business days
? SET BUSDAYS (i think the default is M-F)
SET BUSDAYS = '_MTWTF_'; either have the first letter of the day or an underscore if its not a business day.
If you wanted to include Saturday as a business day then it would be
SET BUSDAYS = '_MTWTFS';
Hopefully its what your looking for,
Leo
February 28, 2005, 07:14 PM
jimboThanks Leo. I had a bit of a brain freeze. I got it using DATEDIF.