There isn't a function in SQL server.
For such a function to work everywhere, you would need to tell it
what country you're in & supply data on what holidays are scheduled.
Often, holidays cannot be determined programmatically & are not
known very far in advance.
Reuters has this data somewhere. Not sure if it's on the Web.
Maybe Bloomberg too?
Nick
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 1:31 AM
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