extract


#1

I have field "song" ex number 021005. First two number are the year of production. how to exctract this two numbers and add 20 for to get in "year" field 2002?
Sorry my bad english
mauro


#2

Action #1:
Action type: Format value
Field: YEAR
Formatstring: 20$mid(%song%,1,2)