SQL to update a date

R

Rick

This question has probably been asked a million times before,

I'm trying to do an update to some dates in a table that are out of whack
by 100 years, presumably due to a Y2K correction that took place too late.

I'm used to using SQL in DB2 so the query I would use to correct this in a
DB2 table would look like this.

update client
set recalldate = recalldate - 100 years;


Unfortunately any similar SQL performed on an Access table produces some
pretty bizarre results.

Any ideas?
 
S

Steve Schapel

Rick,

Try this...
UPDATE Client SET recalldate = DateAdd("yyyy",-100,[recalldate])
 
Top