>>How do I get the following into a date format?
>>

>>m.dos = '20081013'
>>

>>
>>This returns an empty date:
>>

>>CTOD(m.dos)
>>

>
>You should be able to do it using TRANSFORM function, I think.

Do you know the syntax? I'm unable to find a way to use the transform for this.

Borislav's way is how I would normally do it, but I would like a less parsing solution.