Using Imke’s approach, this is what I ended up doing:
1. Extract the last two characters from the source column
2. When the extracted characters contain a number, convert them to numeric
3. Standardize the resulting value to represent the correct year
Read on to see how Matthew pulled it off.