Focal Point
Business Days Calculation

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3371038331

February 28, 2005, 06:50 PM
jimbo
Business 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 L
Not 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
jimbo
Thanks Leo. I had a bit of a brain freeze. I got it using DATEDIF.