>Hi All
>
>I'm looking for a piece of code that can return a valid date given a variety of strings that may be dates. 19980216 returns 02/16/1998 and 2/12/94 returns 02/12/1994 etc.
>
>Any help would be appreciated.
>
>Thanks
I have never seen anything like it, but ctod() can help with the second case. Be sure to use the correct SET DATE setting, and be aware that a date like 2/12/94 can be ambiguous (here in L.America, we would interpret it as 12 February 1994).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)