>Yea, but there's no TTOS().
And no STOD() or STOT(), either.
I've always wondered why that is. If you look in a .DBF file, that's the way dates are stored, as an 8 character string YYYYMMDD. So internally, FoxPro must have a function that does just that.
>
>>Or just plain DTOS() for date fields.
>>
>>
>>>Yes, DTOC(,1) and TTOC(,1) functions has to be used in the index keys for compound indexes to get proper sort order.