avishain (10/23/2013)
Hello there,,i got a variable which is an Expression.
my expression is this:
'||'''DateVar'''||'
i got another variable which is the DateVar and looks like :
02/07/2013
i want to populate the expression and to get this expression:
'||''02/07/2013'''||'
when im trying to do that like this:
'||''@[user::DateVar]'''||'
Dont't use the single quotes.
"||" + @[user::DateVar] + "||".
I assume @[user::DateVar] has the string data type. If not, you need to add a cast.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP