Sorry, there was typo in my code. It should be

WHERE SUBSTR(TTOC(DatetimeField,1), 9,6) BETWEEN "090000" AND "170000"

The TTOC(,1) returns string in the format that is unaffected by date/time settings.

>sergey
>
>i made like this
>"WHERE SUBSTR(TTOC(DatetimeField1), 9,6) BETWEEN "090000" AND "170000"
>
>i got 0 records which is not .t. can tell what is missing
>
>thanx
>bill