>>>Craig
>>>Why do I get ambiguous date/datetime constant error message and for this rountine I do not want to use the time and etc.
>>
>
>>It has to do with your STRICT DATE setting. You can rewrite this as:
>>
>>SELECT Field1, Field2, Field3 ;
>> FROM MyTable ;
>> WHERE BETWEEN(DateField, {^1998/05/05, 00:00}, {^1998/05/12, 23:59:59}) ;
>> INTO CURSOR MyCursor
>
>Craig
>I made a form to pull a report by dates look like this:
>
>SELECT Field1, Field2, Field3;
>FORM MyTable;
>WHERE BETWEEN(Datefield, CTOD(THISFORM.text1.VALUE),CTOD(THISFORM.text1.VALUE);
>INTO CURSOR MYCURSOR
>
>Noe I have a set of record(s)
>
>This is working fine. Is this how I should do this.
>Thanks for all your help.

The textboxes should be formatted to accept a date. They currently receive characters. In the form designer, set the initial value to {} and they should work.