>SQLServer 2000
>
>About 100 records had the month in a datetime field set wrong. I need to set them back but only the month portion in a datetime field. For example:
>
>SQL DATE: 0807171234
>Correct Date: 0806171234
>
>Any ideas on how to change only the month portion of sql datetime field and then specifiy which month?
You can use DATEADD(Month,...,) function
--sb--