IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Business Days Calculation
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Member
Posted
I have some simple date calcs in a define but need to show both in calendar & business days. Has anyone done business day calculations?
 
Posts: 8 | Location: Melville,NY | Registered: August 09, 2004Reply With QuoteEdit or Delete MessageReport This Post
Gold member
Posted Hide Post
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
 
Posts: 95 | Location: Winnipeg, Manitoba, Canada | Registered: January 22, 2004Reply With QuoteEdit or Delete MessageReport This Post
Member
Posted Hide Post
Thanks Leo. I had a bit of a brain freeze. I got it using DATEDIF.
 
Posts: 8 | Location: Melville,NY | Registered: August 09, 2004Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Business Days Calculation

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.