>>I have a table with a field called date - the year is 2016 on all records - how do I change it to 2015 on all records
>>
>>A simple question - I have forgotten how to do this
>
>replace all date with gomonth(date, -12)

It might also be a good precaution to add filtering clause -- just in case (e.g. FOR YEAR(date)==2016 ). Yes, I'm aware that Colin di indeed state "all records" -- but that could be based on viewing a filtered list rather than the unfiltered table (yep, ran into that sort of thing once before with a customer).