Find candidates who were last updated in a certain year e.g. 2009;

select * from person where changedate = '2009'


Update the date of an individual candidate using their personid (found using the method above);
update person set person.changedate = 'insert new year' where personid = 'insert person id here'