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