Using DateAdd function in a update query to add 10 years to the date

[adibakale]

I have a table (tbl_transactions) which has a column(transaction_date) that holds dates in this format mm/dd/yyyy.

The file that is imported has the wrong dates, shows 2005 instead of 2015.

I need to run an update query to correct the dates by adding 10 years to each date in the transaction_date column.

I tried using the DateAdd function but it is not updating correctly and I am stuck.

Here is what I tried so far and I don't know what to put after the 4 x's are in the example below:

DateAdd(yyyy,10,xxxx)

I don't want to change the month or day, only add 10 years to the date.

Any help with this is greatly appreciated

 

[alansidman]

Try this where the Field Name [Field6] needs to be changed to your field name

UPDATE Sheet1 SET Sheet1.Field6 = DateAdd("yyyy",10,[field6])
WHERE (((Sheet1.Field6) Is Not Null));

and change the table name from Sheet1 to your table name.