As Jim has said,
THIS IS NOT A BUG! VFP interprets date literals based on the value of SET DATE. If you have SET DATE AMERICAN then what is inside the {} must correspond to American date formats, namely MM/DD/YYYY. If you have SET DATE BRITISH then what is inside the {} must correspond to British date formats, namely DD/MM/YYYY. This also applies to CTOD - the string must be in the format that corresponds to SET DATE.
>Hi again !
>
>The main bug is when you use quotation like this - {}
>in this case FoxPro understand as American format, but you can
>use function like this - ctod('31/01/2000') main to use this function, not using - {}
>
>P.S. Mr Jim Booth gave to you good advice too ...
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.