This might help get you started:
1) get all the dates between 2 dates using something like
SELECT
the_date
FROM
table
WHERE
the_date BETWEEN CreateODBCDate(date1) AND CreateODBCDate(date2)
then
2) on your CFOUTPUT, something like
<CFOUTPUT QUERY="queryname">
<CFIF #DayOfWeek(the_date)# NEQ 1 AND #DayOfWeek(the_date)# NEQ 7>
#the_date#
<BR>
</CFIF>
</CFOUTPUT>
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 5:31 PM
To: CF-Talk
Subject: business days
i am using SQLServer7. is there a function or custom tag to get the number
of
business days between 2 dates?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
