Use the TTOC() function (not DTOC()!) if you need the date AND the time in the resulted string.

Vlad

>There must be a fairly simple way to to do this, but I'm missing something. How do you convert the DATETIME() value to a character expression? I'm trying to make an index that sorts on a part number (alphanumeric) and then the DATETIME(). I'm building a transaction log that records when a part's information was modified.
>
>Thanks for any help,
>- Brian