>>Hello all.
>>
>>Is there an advantage of using DTOS() over DTOC() or vise-versa when creating a compound index with a date field?
>>
>>Thanks.
>
>DTOS() will create a string that has the year first, then the month, then the day. This works much better for sorting!!
And so will DTOC(somedate,1), but I guess you really knew that? :-)