Can you check if the day number is between 2 and 6 inc.
********** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ********** -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 22 August 2003 9:00 AM To: CF-Talk Subject: Business Day in SQL Query Does anyone have an example, or is this even possible without straining a brain muscle, how to pull data from a MS SQL 2000 database only if that data is date stamped on a weekday?? Has to be done in the SQL query... Thanks for any pointers!! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
