>>>>Nadya,
>>>>
>>>>Try this instead
>>>>
>>>>
>>>>lcDate=dtoc(date()-10,1)
>>>>? between(lcDate,"20001201","20010129")
>>>>
>>>
>>>Thanks to everyone, who replied.
>>>
>>>I solved the problem by:
>>>between(ctod(CharField),date1,date2)
>>>Works fine.
>>
>>Works fine, but it will give you problems with ambiguous dates if SET STRICTDATE is not 0.
>
>It's an old legacy code in FPD2.6 Really, I hate to work with FPD after years of working in VFP. Anyway, it works fine in my tests and hopefully, I would not bother with this crap again :)
Missed the 2.6 part. DTOS() woould still be better IMO, and the code will still work correctly if it ever gets brought up to VFP.