Need a transform which can give the date at which the cost centre got change

Check this post. This should help you