Sorry Ken did not see your post before I shoved my two cents in.

A varchar '0' is NOT a valid date-time format. Date formats are 'mm-dd-yy' examples; '07-09-08'...

This appears to be what you need to do.

"How to add an incremental counter in a SQL Server 2005 Integration Services package by using a Script component in a Data...

Suggest you look at this function available in VB:

DatePart(interval, date[,firstdayofweek[, firstweekofyear]])

The intervalargument has these settings:

Setting Description

yyyy ...

Rather difficult to assist you considering the minimum amount of information you have supplied.

Please read

http://www.sqlservercentral.com/articles/SQLServerCentral.com/62764/ and then reply here with the essential information so that you can receive meaningful...

Before ruling out 2005 read up on the compatability level .. when set it determines how SQL statements will or will not function.

Level Server Revision

60 = SQL Server 6.0...

Most unusual - got the same identical error this morning using SSMS. Unusual in that last night about 10 PM all was fine. Decided to shut down my...

A possible approach is to open your app with a simple form with a window for entering the users SQL Server Login Name - which may or may not be...

Having submitted 4 QOD and struggling to insure that they were clearly worded I can understand the authors problem and appreciate all his work but before condemning BOL may I...

Did you look into the SDK offered as a free download?

It could give you sufficient information so as to be able to write a program using a flavor...

From Books on Line (BOL)

Date and Time (Transact-SQL)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/9bd1cc5b-227b-4032-95d6-7581ddcc9924.htm

Then more from BOL

CAST and CONVERT (Transact-SQL)

specifically CONVERT ( data_type [ ( length ) ] , expression [ , style ]...

In addition to what the others have told you add this aide:

The following will find all views in a database containing the specified text (that is the table name you...

Being a developer in a company unit of some 600 potential users of a application we start out by selecting a group of users ( 2 to as many as...

Jeff ran your codea and got the following:

@Day @monday ...

Think I have it now:

DECLARE @SomeDate AS DATETIME

DECLARE @Day AS INT

DECLARE @monday AS DATETIME

DECLARE @friday AS DATETIME

SET @SomeDate = 'date in week desired '

SET @Day = (SELECT DATEPART(weekday, @SomeDate)-1)

SET...

FORGET THE SOLUTION PRESENTED WHEN THE DAY OF THE MONTH BECOMES A DOUBLE DIGIT for example July 15th THE T-SQL POSTED ABOVE DOES NOT WORK PROPERLY

I should have test...