expression in a text box

[#1]

Hey guys,

Is there any constraints on expressions which can be used in a text box?

i am trying to use this expression in my text box:

  ='Data as of: ' &(if([Time Bucket Name]= 'Current Month' and [Time Bucket Type]= 'CURRENT', Date(MonthEnd([Calendar Date]), 'DD-MMM-YYYY')))

but i am getting the output as: Data as of only.

how can i solve this problem?                   

[rajni_batra · Accepted solution]

it will give u result on selection only....

What exactly you want