I have a STRING field that contains a date in format "dd/MM/yy". When passing that value in YEAR function is not always correct. Sometimes is +1, other times is +2.
07/08/53 gives 53
22/09/53 gives 54
29/08/54 gives 56.
I cant find a pattern.
Of course the field should have been date and using SimpleDateFormat and then YEAR works fine