>Rick
>
>Naomi said quote
>it doesn't make sense to use DTOC as is anyway, because the rows will not be properly sorted.
>unquote
>
>on which you replied with quote
>INDEX ON DTOC(dMyDate)...
>unquote
>
>so my thesis is:
>Naomi is 100% correct - one is not suppose to use dtoc() in an index expression, use dtos()
>
>please note correctly.
>Regards,
>Koen


My statement here is also correct. The DTOC() index will work correctly until a date-related setting is changed. That is based upon years of use and personal testing in VFP9SP2. It may not sort properly without setting a specific date format, but it works properly.