>I'm playing around with trying to determine if a character string is actually a date. The only way dates come into this is CCYYMMDD, so it makes it a little easier. I know this isn't good enough to exclude all non-dates from being converted. What else can I do?
>

>CASE ;
>	BETWEEN(VAL(SUBSTR(m.FormatFieldValue,1,4)),1900,2050) ;
>	AND BETWEEN(VAL(SUBSTR(m.FormatFieldValue,5,2)),1,12) ;
>	AND BETWEEN(VAL(SUBSTR(m.FormatFieldValue,7,2)),1,31)
>	oDetails.FieldVal = ConvertFormat('D8',m.FormatFieldValue)
>

Seems to me you could just use CTOD() with an appropriate SET DATE. If you get a date back, it's good. If you get the empty string, it's no goo.

Tamar