>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.