Why you don't use DTOS()?
>To create a compound index key, you've to convert all fields to the character type.
ssnumber + DTOC(orderdate,1)
Notice the second parameter used in DTOC(,1) function. It converts a date to the text format suitable for an index key.
>
>
>>I am trying to set a primary key for a character field and a date field through an expression. I have thhe following:
>>
>>ssnumber+orderdate
>>
>>ssnumber is a character field and the orderdate is a date field. When I try and save it I get the following:
>>
>>Operator/operand type mismatch
>>
If it's not broken, fix it until it is.
My Blog