Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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);
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.
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)