What DBMS are you working with? -----Original Message----- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 11:50 AM To: CF-Talk Subject: Re: Calculating workdays
i have been looking for something like this forever and have not found it. Or even a way to do it without making clunking code. On Thu, 24 Jan 2002, it-werks wrote: > I could have sworn there was a tag on the developer's exchange, but I sur e > can't find it. > > I am looking for a tag, formula or whatever is needed to do the following : > When a number is entered into a form field named "leadtime" and a date is > put in a form field named "need_by" a results field will be the calculate d > date that > is the number of WEEKDAYS(mon-fri) BEFORE the Needed Date. > In other words: I need the date to order a part which has a leadtime of x > number of workdays before the needby date. > > Sure could use some help here. > > Terry Troxel > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
