DTOS(date)
* OR
DTOC(date,1)

>
>I'm porting my app from VFP 7 to 9, and one index key (reference+DTOC(date)) I have set up generates an 'error building key index' when I try to insert (date) value (date()). The strange thing is that if I open the table and just do a reindex, it works fine but if I run it through Stonefield's reindex proc, I get the error. I know I shouldn't be using DTOC, and the strictdate setting doesn't have any effect.
>Should I change the index or SDT or both, or do something else altogether?
>
>Thanks
>Luke