Parse Error

[HopeCQ]

Hello, I'm receiving a parse error message for the following formula but can't figure out the issue. Any suggestions? Trying to avoid a work-around solution. Thanks in advance!

 

 

[Prometheus · Accepted solution]

The field you're trying to create has a data type of V_WString. If you want to keep it as that, make sure the values you're trying to place in that field are also string. That is, put your years in quotes, like THEN "2028". If you want the field to be numeric, you can change the data type to Int and you won't have to put quotes on all your year values.

[HopeCQ · Accepted solution]

Perfect, many thanks!