Alex,
Here is how to do it in SQL Server (assuming Saturday and Sunday are not
business days)
Select count(*) as daycount
>From DateTable
Where DateTable.EntryDatetime >= [beginnindate] AND DateTable.EntryDateTime
<= [enddate]
AND ((DateName(dw, DateTable.EntryDatetime) != 'Saturday') AND (DateName(dw,
DateTable.EntryDatetime) != 'Sunday'))
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 8: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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
