replace year in field date

[sal21]

How to replace the year in field DATE, without change the dd/mm, based a MyYear var Integer

[HansV]

Code: Select all

SQL = "UPDATE [MYTABLE] SET [DATE] = DateSerial(" & MyYear & ",Month([DATE]),Day([DATE]))"

[sal21]

Code: Select all

SQL = "UPDATE [MYTABLE] SET [DATE] = DateSerial(" & MyYear & ",Month([DATE]),Day([DATE])"

Peraphs, One closed parenthesis to the last character in SQL?

[HansV]

Sorry, there should be two closing parentheses. I will correct my previous reply.

[sal21]

Sorry, there should be two closing parentheses. I will correct my previous reply.

O no problem Bro!