I asked about DBMS because you can create a null table select function call with the same kind of code in either SQL Server 2000 using T-SQL or on Oracle using PL/SQL thru OLEDB/ODBC.
-----Original Message----- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 12:09 PM To: CF-Talk Subject: RE: Calculating workdays I used something like the following to work out the number of working days between 2 dates. You should be able to manipulate to get what you want: <cfloop condition="#daysadded# LT #stagelength#"> <cfset nextdate = DateAdd("D",1,nextdate)> <cfif DayOfWeek(nextdate) IS NOT 1 AND DayofWeek(nextdate) IS NOT 7> <cfset daysadded = daysadded + 1> </cfif> </cfloop> -----Original Message----- From: Chris Combs [mailto:[EMAIL PROTECTED]] Sent: 24 January 2002 17:03 To: CF-Talk Subject: RE: Calculating workdays 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 > > ______________________________________________________________________ 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
