>>I have two fields that are DateTime(). What is the best way to index them? I have tried:
>>
>>INDEX ON TRANSFORM(Field01) + TRANSFORM(Field02) ASCENDING TAG Temp
>>
>>But they don't seem to order correctly. I would also like the index to be as efficient as possible.
>
>Jay, I use dtos(datefield), because it puts it in order by year/month/date. The dtoc() gets it into a string but the order may be a little strange because the year is last.
DTOS is for date fields, not for datetime. For datetime it's TTOC(field,1)
If it's not broken, fix it until it is.
My Blog