I'm pretty new to formulas in crysatl:
Have a date string in this format on a report field:
20120101
I'd like to simply convert that to 2012/01/01, or yyyy/mm/dd

I'm trying to use:

StringVar DT := '{Command.STUDY_DATE}'
Date (
Val (DT [  1 to  4 ]),
Val (DT [  5 to  6 ]),
Val (DT [  7 to  8 ]) )

The date value is obtained by means of a command.

When I run in formula workshop, it tells me:
"The remaining text does not appear to be part of the formula"


Thoughts?
Rich

just added in another "+" and it looks good!
thanks!!!!!!

I was not sure if the StringVar DT := '{Command.STUDY_DATE}' would convert to a string.  I thought DT would have the value {Command.STUDY_DATE} not the value of {Command.STUDY_DATE}.