IDS Forum

RE: Date calculation excluding weekends

Posted By: Scott MacKenzie
Date: Thursday, 4 September 2008, at 11:09 a.m.

In Response To: Re: Date calculation excluding weekends (GARY GU)

And you work on Holidays!!!

-ScottM

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
GARY GU
Sent: Thursday, September 04, 2008 12:57 AM
To: ids@iiug.org
Subject: Re: Date calculation excluding weekends [13279]

May need a stored procedure to do this:

create procedure workdays(d1 DATE, d2 DATE)

returning int;

define ld1,ld2 DATE;
define n int;

if d1 > d2 then

let ld1 = d2;

let ld2 = d1;
else

let ld1 = d1;

let ld2 = d2;
end if;

let n = 0;

while ld1 < ld2

if weekday(ld1) between 1 and 5 then

let n = n+1;

end if;

let ld1 = ld1 +1;
end while;

return n;

end procedure;

select workdays(current, date('08/09/08'))
from systables
where tabid = 1
;

and returns 2.

Gary

--------------------------------------------
Hi all,
I would much appreciate if some guru advises me of some quick fix 4GL
function
that calculates the difference between 2 dates excluding the weekends.
Eg: let work_days = date_end - date_start.
If date_start is today, which is Thursday 04/09/2008, and date_end is
Monday
08/09/2008 the work_days is 4. But excluding the weekends (Sartuday
06/08/2008
and Sunday 07/08/2008) then the actual work_days is 2 9and this is the
number
I want).
Best regards,
Long NGuyen
Informix 4GL Programmer
TTLABS system - ARCBS
153 Clarence street - Sydney
Australia.

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Date calculation excluding weekends
  Long Nguyen -- Thursday, 4 September 2008, at 12:49 a.m.
  • Re: Date calculation excluding weekends
    GARY GU -- Thursday, 4 September 2008, at 2:56 a.m.
    • Re: Date calculation excluding weekends
      Long Nguyen -- Thursday, 4 September 2008, at 7:04 a.m.
    • RE: Date calculation excluding weekends
      Scott MacKenzie -- Thursday, 4 September 2008, at 11:09 a.m.
      • RE: Date calculation excluding weekends
        Clifton Bean -- Thursday, 4 September 2008, at 11:23 a.m.
        • Re: Date calculation excluding weekends
          Long Nguyen -- Friday, 5 September 2008, at 12:35 a.m.
      • Re: Date calculation excluding weekends
        Long Nguyen -- Friday, 5 September 2008, at 12:33 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.