>>>>Hi all,
>>>>
>>>>I have a compound index on the following expression, cnoee+DTOS(dtrans)+cdtrans where cnoee is Employee #, dtrans is date and cdtrans is code. Is there any way I can do descending on dates but acending on the others? Presently I can only think of using a large number to minus DTOS(dtrans). Any other way?
>>>>
>>>>Thanks.
>>>
>>>Farouk,
>>>
>>>Try this. 'index on cnoee+STR({12/31/2099}-dtrans)+cdtrans'. Please let me know if this is successful.
>>>
>>>Good Luck,
>>>
>>>Bill Chadbourne
>>>wchad@ime.net
>>
>>Instead of hard coding a date, why not just use the DATE() function? You'll never have a transaction dated tomorrow will you?
>>
>>If not, use Bill's idea like this:
>>
>>cnoee+STR(DATE()-dtrans)+cdtrans
>>
>>PS. hey Bill, with that LOOOOONNGG COBOL thread, don't you think we've learned not to make date related assumtions? (eg)
>
>i'm sure i won't be around to fix the Y2100 problems...

Spoken like a true COBOL programmer ;) I know, I used to be one.