>>>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.
>
>Not really, because 01/01/01 is a date, but not one I want. I guess I could do the same thing as you suggested and put a BETWEEN with a date range though to handle that.
Yeah, that would work.
Tamar