Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have three variables vStartMM vStartYY vSTARTMMYY within vStartmm and vStartYY I have fields which change based on selections made (they are ok). What I require is to take these two variables and concatenate them into one variable vSTARTMMYY.
Within the Variable Overview - Definition- I am using the CONCAT function. I have looked high and low for just one example that would be of use and I cannot find one - ANYONE help please.
You can use the concatenation operator & instead to concatenate two strings:
=vStartMM & vStartYY
LET vStartMM = ....
LET vStartYY = ...
LET vSTARTMMYY = $(vStartYY)$(vStartMM);
let me know
You can use the concatenation operator & instead to concatenate two strings:
=vStartMM & vStartYY
Thank you but I am thinking this would be ok in the script but inside the variable Overview (Definition)its not working.
Looks like I didnt need 'concat' any way - no wonder I couldnt get it to work. This has resolved my problem. Thankyou.
Hi me again- I am very close to my solution just one little problem. When I concatenate the two variables (one of which is month) the value is a single digit for Jan to Sept where I need it to be two digits ie 01 for Jan up to 09 for Sept.
My selections and subsequent analysis works ok when I select Oct Nov Dec. as they are 10 11 12.
Any suggestions??
Right('0'&Month_var,2)
Num(vStartMM,'00')
Thanks guys much appreciated.