Replacing date field with another date

[Anonymous]

So I have this table:

Is there any way that for companies that have a company set of 'Term' to have their 'end date' replaced with their 'lastChange' date? We have some bad data and a lot of companies are termed but for some reason have a future end date. We would like to use the lastChange field in place of since that date is most likely the date they actually termed. This seems tricky because for the companies that don't have a 'Term' company set, we would like to continue using the actual end date populated for them. Thanks!

[jthomson · Accepted solution]

The easiest way to do this would be to create a new column that looks at your companyset field and then pulls through lastchange if it's Term or enddate otherwise, i.e. an if statement. Actually replacing the data in the existing field is a bit more convoluted