Re: Need Function to calculate valid workhours

In article <30nbqq$gkd@infmx.informix.com> proberts@informix.com (Paul Roberts) writes: >In article <ladCtBJEn.J41@netcom.com> lad@netcom.com (Louis D'Ambrosio) writes: >>Hi Everyone :) >> >>I have a need for a function that can calculate the total of hours >>between two supplied datetimes. >> >>The function must be able to know to not add Holidays and Weekends >>and for the hours of 6am to 5:30pm only. > >If this function is able to figure out when Easter falls, I'll be >very impressed! My boss has written a library that calculate anything you want with dates, and possibly times, too. It handles informix, unix, julian, long(yyyymmdd) formats and converts between them. It handles all global hollidays pluss national customizing. The functions are optimized and fast. He is on vacation for another two weeks, but you can probably drop him an e-mail at dag@boers.no I don't know if he will give you the source code, but he can sure give you some deep insight and good pointers. -- Sincerely, SoM --------------------------------------------------------- From: Knut E. Vonheim Sign.: SoM Comp: A/S OBI Addr.: Fred Olsensgt. 1 0152 Oslo Phone : + 47 22 34 18 06 Norway Fax : + 47 22 42 68 47 e-mail knutv@boers.no Beeper: + 47 966 99357 --------------------------------------------------------- In my opinion, it shouldn't be just my opinion !!!!