Re: Count days without week-end

Phillippe Approach 1 - write or procure a datablade. Involves either programming effort or big bucks or both. Approach 2 - populate a table (called weekends, say) at the beginning of the year with all weekend dates, and then run the following... SELECT '2000.09.26' - '2000.09.22' + 1 - (SELECT COUNT(*) FROM weekends WHERE weekend_dates BETWEEN '2000.09.22' AND '2000.09.26') FROM systables WHERE tabid = 1; Cleaner approaches based on the above may be possible - I am merely extrapolating from something concerning mandatory holidays I had to do in the past. HTH Sujit philippe juillot <philippe.juillot@siemens.at> on 09/28/2000 04:32:55 AM Please respond to philippe juillot <philippe.juillot@siemens.at> To: informix-list@iiug.org cc: Subject: Count days without week-end --------------C1983803407A6C285B7EE2C9 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hallo, We want to count the days between 2 dates in 2 ways: * all the days: select '2000.09.26' - '2000.09.22' + 1 from systables where tabid = 1; Result ist 5 days ... no problem! * the days without the week-end: Result must be 3 (Friday, Monday, Tuesday) How can I do this? The interval between the 2 dates can be more than 1 year. Many thanks for good ideas Philippe Juillot --------------C1983803407A6C285B7EE2C9 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> Hallo, <P>We want to count the days between 2 dates in 2 ways: <UL> <LI> all the days:<BR> select '2000.09.26' - '2000.09.22' + 1 from systables where tabid = 1;<BR> Result ist 5 days ... no problem!<BR> <BR></LI> <LI> the days without the week-end:<BR> Result must be 3 (Friday, Monday, Tuesday)<BR> How can I do this? The interval between the 2 dates can be more than 1 year.</LI> </UL> Many thanks for good ideas <BR>Philippe Juillot</HTML> --------------C1983803407A6C285B7EE2C9--