"r" <r@r.com> wrote in message news:uKTaIq76FHA.268@TK2MSFTNGP10.phx.gbl...
> How do I update a date field to reflect a specific date? My field is
> formatted at smalldatetime.
>
> I've tried:
>
> UPDATE dbo.Dealers
> SET dbo.Dealers.BillQ2 = 2005/11/14
> FROM dbo.Dealers, aipdn.qtr2
> WHERE dbo.Dealers.DealerCode = aipdn.qtr2.DealerCode
>
> And I've tried it as 11/14/2005 also.
>
> ??
>
>
>