Thanks so far. I can't seem to get your example to work using the table I am using.

Can you advise how to amend it to use the sample table...

Never consiered 'exact years' ago. Assuming today is '2014-02-09' and the date in the table is '2010-02-09', I would want this updating to today ('2014-02-09'). If I ran...