updating just the date in a date field...

Hi all...

I have a table with a shipDate field. I need to go through and where there are shipdates on the 10th of the month, I need to switch them to the 28th. The field is of type smalldatetime. For instance, I have an item to ship on 9-10-2004, but now I need it to change to 9-28-2004. Month and year need to stay the same.

I tried this on just one test record:

update item
set date(pubdate) = 28
where isbn='1-59355-074-X'


but it didn't work... any suggestions?

thanks all...

Jill

Nevermind... After I got past my blonde moment, I realized I could do it in 10 minutes using .ASP.

Duh...