Re: Counting days

Posted in 1996

Kate Juliff — 24 Jan 1996 22:41:00 -0500 — source: Informix-list mailing list archive (1991-1998)

In article <4e5r5b$qum@brsuni.ifl.co.uk>, Paul Watyson <ifpxw@ifl.co.uk> wrote: > > >I want to count the number of weekdays between the dates >using only sql. > >Anybody got any ideas > > >Than, I've done that. I just subtract the earlier date from the later one, and then the count of the number of Saturdays and Sundays. I've forgotten exactly how I did that, but suspect I had a loop and checked within the loop. Can look it up if you need (email me). Kate > >Paul Watson >International Factors Ltd >