Can you send me the form and some simple data?
>hi,
>What type is Dat field? character type.
>
>thanks.
>
>>What type is Dat field?
>>
>>>hi,
>>>thank you,
>>>the type is date ,but i get it at my text via calender,
>>>Yes,dat field at my table.
>>>

>>>thisform.text1.value= CMONTH(This.object.value)+' '+Str(year(This.object.value))
>>>&&thisform.olecontrol1.Visible=.f.
>>>

>>>>Mohhamed,
>>>>What type are m.dat1, m.dat2 AND dat. I hope Dat is Field from table
>>>>
>>>>
>>>>>hi all,
>>>>>any idea ,help.
>>>>> to fix this code under,
>>>>> I want to see only what I choice between to dates but I see all months,
>>>>> thanks.
>>>>>
>>>>>
>>>>>

>>>>>SET CENTURY on
>>>>>SET DATE TO british
>>>>>SELECT divi
>>>>>m.nam=nam
>>>>>m.dat1=thisform.text1.Value  && result is january   2005
>>>>>m.dat2=thisform.text2.Value  && result is feb...2005 or any month i choice
>>>>>SELECT table1 && error message table1 not found, I need to use it to make index
>>>>>INDEX ON dat TO kk
>>>>>
>>>>> SELECT * from table1 WHERE   (dat between m.dat1 AND m.dat2) AND dvno=VAL(this.Value) and peri=thisform.combo2.value ;
>>>>>     into CURSOR xyz
>>>>>IF _TALLY > 0
>>>>>             report form newtable1 preview
>>>>>  ELSE
>>>>>        =MESSAGEBOX("Still No Product")
>>>>>
>>>>>Endif
>>>>>

>>>>>m.qasem