>>yes, you should do the DTOC, but you should also be aware that the order of the file using this as an index will vary greatly depending on the date format being used! mmddyy, yymmdd, yyyymmdd, ddmmyy; see what im getting at!?
>>
>>when necessary to create such an index, i usually (depending on need of the order being created) create a separate char field to mirror the date field with a format of yyyymmdd, this assures a descending order.
>
>In this situation, I would use DTOS(DATE(),1).
Yes, now I recall that's the right one for this, though it's ascending if you're going to concatenate strings, so you'd still have to get descending secondary order if you want that...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.