>>>I would like to have a sql to gather a set of records based on a date field. For example I have several records in my table, say for the month of May I want to only select May 5th thru May 12th. If someone could show me example I would be very appreciative...
>>>
>>>Thanks Randy
>>
>>
>>SELECT Field1, Field2, Field3 ;
>> FROM MyTable ;
>> WHERE BETWEEN(DateField, {05/05/98}, {05/12/98}) ;
>> INTO CURSOR MyCursor
>
>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