Setting a Variable Definition In Script

[paul_hallwood]

I'm trying to create a variable within script that will then display this variable in a text box.  Currently in the script I have:

SET varData_Status_Year='=[Year] & '/' & ([Year] + 1)';

(where [Year] is the year selected by the user)

The output I am trying to get is e.g. 2013/2014

But when I reload the information and look at the textbox, all I get displayed is the text =[Year] & '/' & ([Year]+1) despite assigning the variable varData_Status_Year to the textbox.  It's as if the definition of the variable hasn't been evaluated.

Any ideas warmly welcome.  Can I even concatenate existing fields with text to create a variable???

[Anonymous]

Try this:

SET varData_Status_Year=[Year] & '/' & ([Year] + 1);

[ashfaq_haseeb]

Hi use let instead of set

LET varData_Status_Year=[Year] & '/' & ([Year] + 1);

Regards

ASHFAQ

[paul_hallwood]

Hi Michael - just tried that and I get the same as what I was getting previously but without the single quote at the start and end.

[paul_hallwood]

With your suggestion Ashfaq, I just get a forward slash being displayed in the textbox.

[Anonymous]

What exactly is in your text box?

varData_Status_Year

or

=varData_Status_Year

or

=$(varData_Status_Year)

?

[ashfaq_haseeb]

Hi,

Select at least one year.

Regards

ASHFAQ

[paul_hallwood]

The second one of your options i.e. =varData_Status_Year

I have tried the other two options but they haven't given me what I wanted either.

[paul_hallwood]

Hi Ashfaq,

I have selected one year and this doesn't change anything unfortunately.

[Anonymous · Accepted solution]

See attached