is there a way to change just the last four digits of a date? I just need to change the year on several records.

I'm sure this can be done, but you need to give more details. Are you wanting to add a certain number of years to the date? Or do you want to change a specific year of dates to another year? We need more details to give an exact answer.

RDH

the dates are currently 10/24/1920 and 10/24/1900. I need them to be this year.

thanks

Determine the earliest twentith century year that is valid. Then create an update query that selects all dates earlier than 1/1/xxxx and add 100 to the year using the DateAdd() function.

that was it. Thanks. It took a bit a tweaking. I checked OnLine help and the first time I ran it it changed everything and gave me 2720 for the year. But I finally got it. Thanks again