Trigger the formula in an input box variable whilst loading

[tinkerz1]

Hi,

I have create a variable in QV for entry through the input box 

='\\Test1\Test2\Test3\' & Date([Month End Date],'YYYYMM') & 'Data\'

I then want to call it in the load script

But I get the formula not the output

$(var1)

'\\Test1\Test2\Test3\201009\Data\ '

How can I get the formula?

[swuehl]

I think you would need a second variable that evaluates the code in the script, like

SET vInput = '\\Test1\Test2\Test3\' & Date(Today(),'YYYYMM') & 'Data\';

LET vEval = $(vInput);

[tinkerz1]

Vinput will be input buy the end user, so the load sript will have to collect it.

Vinput will be an input box so this has not worked for me.

[swuehl]

Not sure if I understand what you are trying to tell me.

It doesn't really matter how vInput is created, if it's not evaluating the embedded QV function, I think you need a second variable to evaluate your text. You can create this second variable in the script using LET, potentially also in the variable editor:

=$(=vInput)