Download Latest Version tpc-c-ifmx.tar.gz (392.7 kB)
Email in envelope

Get an email when there's a new version of IIUG Software Repository

Home / Informix4GL-Tools / work_days
Name Modified Size InfoDownloads / Week
Parent folder
readme.txt 2020-05-11 960 Bytes
0
work_days.4gl 2020-05-11 22.0 kB
0
Totals: 2 Items   22.9 kB 0 
Newsgroups: comp.databases.informix
Subject: Number of working days


From: jparker@hpbs3645.boi.hp.com (Jack Parker)
Date: 31 Aug 1995 15:23:04 -0400

Folks,

What I find really annoying is deleting mail which had a name and address
which I didn't bother to save anywhere.  Some worthy was just worrying about
number of working days between two dates in SPL.  He had already done the
work of stashing the Holidays into a file and doing

   end_date - start_date
   - COUNT(*) from holidays
   between start_date and end_date

He had yet to worry about subtracting out Sundays and Saturdays, since this
is something I've wanted and should properly belong in THE date library which
I volunteered to write 8 years ago, I went ahead and wrote it. I did it in
4gl, so there will be some minor conversions to make it run in SPL, but
it should go quietly.

As always I could have taken some short cuts, but chose instead to keep the
code clear.

For your pleasure:
Source: readme.txt, updated 2020-05-11