Hi Michael,

How about:

cDate = "20010601"
dDate = DATE(VAL(LEFT(cDate,4)),VAL(SUBSTR(cDate,5,2)),VAL(RIGHT(cDate,2)))

Hope this helps,
Gavin...

>Is there a function that does the opposite of this and converts a string, such as "20010601", to a date (CTOD() does not work unless there's a "/" in there)?