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)