I did this a while back - can't remember if I did it using a custom tag or not - I'll try to dig out the code and post it here or email you the tag off list (if I did have the foresight to put it in a tag)
------------------------------------------------------------------ Andrew Ewings Director Thoughtbubble Ltd Media Development House ------------------------------------------------------------------ United Kingdom <http://www.thoughtbubble.net> <http://www.thoughtbubble.co.uk/> Tel: +44 (0) 20 7387 8890 ------------------------------------------------------------------ New Zealand <http://www.thoughtbubble.co.nz/> Tel: +64 (0) 9 488 9131 ------------------------------------------------------------------ The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -----Original Message----- From: Alex [mailto:[EMAIL PROTECTED]] Sent: 24 January 2002 16:50 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 > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
