Dates in Update Queries

  • Thread starter Thread starter Mike Comtois
  • Start date Start date
M

Mike Comtois

Is there a way to run an update query to update to update
a date field to a specific date of THIS year?

For example, If I run the query now it will update all
the dates to 3/10/2004 and if I run it in one year,
without changing anything it will update the date to
3/10/2005.

Any help would be great! Thanks!
 
UPDATE tblYourTable
SET [DateField] = DateSerial(Year(Date()), Month(DateField),Day(DateField));
 
Back
Top