>Hi,
>
>If I want to use SQL syntax to gather records within a date range, what is the best approach (that yields fastest response) to indexing date fields ?

What Sergey and Tore said is the ticket. Anything else is indexing on strings or numbers containing date in some format, and then you have the dependency on the chosen format. Which will come around and bite you sooner or later.

If you really need a date field in a composite index, then use dtos(datefield) - that's an unambiguous format (yyyymmdd).