Hi,

We have a code that is a text field

it's a three digit number - three letter month followed by two digit year

example

225-Aug16

we need a script to be able to add a value of 10 to the first three digits whilst at the same time add 1 to the 16.

So essentially change 225-Aug16 to 235-Aug17

Is there an easy way to do this?

Let ( [ T = yourTextFieldHere ;

N = right ( "00" & left ( T ; 3 ) + 10 ; 3 ) ;

Y = Right ( T ; 2 ) ];

N & middle ( T ; 4 ; 4 ) & Y

)