I have a date field that needs to be updated. I created a query with criteria that my field [StartDate] is = or < date() -365. This returns only the records that are 1 year or older. I then used the query to make thae form. What I'm trying to do is increase that [StartDate] by 1 year on the form. I am using a macro set the value, and the value I'm using is: DateAdd("yyyy",1,[StartDate]), but I get the 1230/1899 date. What am I doing wrong?