Hi,
Create three formulas and insert the below code
Formula 1
//Below logic will display 2017-52HY
mid{Database_Field},,2,4)&"-"& mid({Database_Field},6,2)&mid{Database_Field},,9,2)
//Below logic will displau 217-52HY
mid{Database_Field},,2,1)&mid{Database_Field},,4,2)&"-"& mid({Database_Field},,6,2)&mid{Database_Field},,9,2)
//Below logic will display 5AJ2
Mid{Database_Field},,11,4)
//Below logic will display 0
Right({Database_Field},1)
--Praveen G