I am already doing SET DATE <> respectively. please run the code and check.

>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.
>