MSSQL 2000 DATEPART(DW, DATEFIELD) BETWEEN 2 AND 6
The weekday (dw) datepart returns a number that corresponds to the day of the week, for example: Sunday = 1, Saturday = 7. The number produced by the weekday datepart depends on the value set by SET DATEFIRST, which sets the first day of the week. >>> [EMAIL PROTECTED] 10/05/2005 12:03:05 pm >>> CF7 JDBC Informix or MSSQL SERVER 2000 current format for start_date end_date is (varchar) and is seen like 1996-05-24 looking at it from the database. has anyone got a script or used a script to do strip weekends from a date range (varchar range). Regards Chris --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
