concatenation help

[former_member183990]

Hi gurus,

I am creating a formula field where in which in need to concatenate two fields along with some symbols

the formula is as follows

Local StringVar x 
x = DateValue (AUBURN__DES_PROJ_INFO.ESTACTSCOPECOMPDATE)
Local StringVar y
y = AUBURN__DES_PROJ_INFO.SCOPEPROJVARIANCE
x & "(" & y ")"

kindly guide me in completing this requirment

looking forward for a positive reply

note: i am new to this crystal reports

Regards

S.Janagar

[Former Member · Accepted solution]

Try

Local StringVar x;

x:= DateValue (AUBURN__DES_PROJ_INFO.ESTACTSCOPECOMPDATE);

Local StringVar y;

y:= totext(AUBURN__DES_PROJ_INFO.SCOPEPROJVARIANCE);

totext(x, 'dd/MM/yyyy') & "(" & y &")"

Ian