Hey Brian,
Take a look at TTOC(). Make sure you use the ,1 argument for accurate indexing on char expressions.
INDEX ON TTOC(mydatetime,1) TAG MYDateTime
hth,
>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
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote TechnologiesDeveloper's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development