> I used the YEAR_OF (date), MONTH_OF (date), and DAY_OF_MONTH (DATE)
> functions to extract numeric typed data, then used the TO_STRING function
> to
> convert these to a string variable which I used in the needed string concat
> operation.

Did you deal with the issue of needing to insert a leading zero for
months/days/years less than 10 if you're trying to come up with a MMDDYY
kind of value?

Gavin