Trim Date from field

[burrina]

I have a lot of records where I need to update the Year on a date table and the field name is CalendarDate and i need to update the year to 2012. The table being used is named tblcaldate. Here is a screenshot.

[pbaldy]

You can use the DateSerial() function, using Month() and Day() for those arguments and hard-coding the year.

[burrina]

Tried using this is a update query but it is wrong syntax, close, but no cigar!
Criteria 2013
=Right("CalendarDate",4)

[pbaldy]

No, the DateSerial function would be the way to go.

[peaceup]

Hello
use Query Update
see attach picture

[burrina]

The actual name of my field is CalendarDate I assume I replace datestg with CalendarDate is this correct ?

[peaceup]

yes,
CalendarDate
tblcaldate
DateAdd("yyyy";3;[CalendarDate])

[burrina]

Thanks, I appreciate that, it saved me a ton of work.