I want to be able to take the year field data, remove the first two characters [19 or 20] and add the last two numbers to the end of the Title field inside round brackets ().
Thanks for any help..
I want to be able to take the year field data, remove the first two characters [19 or 20] and add the last two numbers to the end of the Title field inside round brackets ().
Thanks for any help..
Take the converter menue Tag-Tag.
Field: TITLE
Format String: %title% ($right(%year%,2))
You can also use this format string with an action of the type "Format Value".