I have 3 different fields that track year in the form of text (4 characters). I'm trying to create a new formula field that would give me the latest year out of all 3 fields.
For example: field1= 1999, field2=2002, field3=2011, the formula should return value 2011. All fields are text right now so it might need to be converted.
Any help is appreciated!