You where right, It works, the problem was in another assignment in the same UPDATE sentence.

I'm very surprise. All my live I've strugled with date format in my programs and...

Hi. Thanks for answer so fast.

VigenciaSeguro is an smalldate field in my SQL Server table.

I'm trying to assign the value : '20030721' , wich is a date in ISO format,...

I used the ISO format and didn't work.

I'm using a Smalldatetime field and tried to do the assign :

VigenciaSeguro = '20030721

Instead of a succes message I get a Msg...