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

It doesn't matter what you SET DATE to in your code, it is whatever the current setting of it is when you COMPILE the code that matters to the constant!