TM1 Forum

hi,
i have a requirement like i need to pull date from oracle db and display it as 'dd-mmm-yy-ddd' format.So i pulled date and day(using to_char(date,'dy')) in two separate variables from oracle and tried to concatenate in ti process .but i didnt find a function to concatenate it in the turbo integrator.IS there any function to do it?

thanks and regards,
angel

angel1234 wrote:hi,
i have a requirement like i need to pull date from oracle db and display it as 'dd-mmm-yy-ddd' format.So i pulled date and day(using to_char(date,'dy')) in two separate variables from oracle and tried to concatenate in ti process .but i didnt find a function to concatenate it in the turbo integrator.IS there any function to do it?

It's not a function; you use the pipe character as the concatenation operator. It's just above the [Enter] key.