>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)
>
Make sure you are in a try..catch structure. If the conversion throws an error, you know your date was screwed.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________