sql (fwd)

> > I am trying to write a SQL statement that will look at 2 dates and determine > the number of work days there are between them. I need to issue the SQL > against many rows. If I can at least exclude the week-ends that would be > great. The holidays, a bonus.... Does anyone have an answer? > Actually I just finished writing a chunk of code to do date arithmetic handling weekends and holidays. It's in 4gl. Somebody else recently sent me an SPL which does date arithmetic - I don't think it handled holidays. Holler at me if you want a copy. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ "I'm with the IRS, I'm here to help you" _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________