>>>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.
Um, this is 2.x so strict date is a problem but other date formats could be. So...you'd
lcdateset = SET('DATE')
SET DATE MDY
SET DATE (lcdateset)
George
Ubi caritas et amor, deus ibi est