>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).