>>1. I have a form and a table AAA.
>>The user will input the start date and the end date in 2 text boxes in the form. TEXT1 and TEXT2 for example. Then I want to use these 2 dates to select the record in the table AAA by calling a Query. I don't know how to set in the Query desinger.
>>SELECT *;
>> FROM AAA;
>> WHERE AAA.date = ???
>>
>>2. And I have tried to run
>> WHERE AAA.date = "1999/01/01"
>>The error message is "Operator and Operand mismatched."
>>What format should I use for the date?
>
>Power,
>
>The delimiters for dates are {} the curly braces. If you are using VFP6 or VFP5 you are best served to specify date constants in teh strictdate format, that is {^1999/06/19} The carot ^ signifies the strict date format, the format is YYYY/MM/DD. Using this format removes any ambiguity resulting from the SET DATE setting.

Power> Hi, Jim, it is you again. :) Firstly, thanks for your help about the curly braces. But my question is that I don't know how to use the start date and end date of the 2 text boxes in the form to the query so I can select the record in that table from start date to end date. I cannot use
SELECT *;
FROM AAA;
WHERE AAA.date = thisform.text1.value
Right? What should I do?

Thanks
Power