Substrings

@tvinci, you’re going to have trouble supporting this app if you don’t understand these expressions.

1 Like

Turns out I was wrong on being able to use NUMBER() on a List of values.

So try subbing NUMBER() for EXTRACTNUMBERS().

1 Like

IT WORKED! :slight_smile:

1 Like

Woo! And hopefully, without any intervention, next year will automatically start at 21-R1.

It should because year(today()) returns the year programatically.