Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting DATETIME() to Character
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00092809
Message ID:
00092881
Views:
20
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 Technologies
Developer's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development
Previous
Reply
Map
View

Click here to load this message in the networking platform