FORMAT ()

[ranjankumar]

i use cognos 8.2 and database as Teradata .
I need to concatenate two date ( this i can do ) and display the date format as mm/dd/yyyy .In teradata  this format function can be done. but in report i cant implement this. so it shows output of two date concatenation as ( 99/12/31 - 99/12/31 ).. i need output as
"12/31/9999 - 12/31/9999"