Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create a STOD command/function?
Message
From
03/05/2002 20:36:01
Bill Totten
William Totten & Associates, Inc.
Indiana, United States
 
 
To
01/05/2002 11:58:26
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00651378
Message ID:
00652699
Views:
15
Pete:

The DTOC() function has a ",1" argument that creates a string as YYYYMMDD.

How's this;
1.) Create an index tag with this format;
INDEX ON DTOC(CTOD(serv_date),1) TAG serv_date_YYYYMMDD

2.) Then, format the field accordingly so you can find it (or FOR clause it) quickly;
m.serv_date = DTOC(CTOD(serv_date)),1)

You could then use the m.serv_date var for lookups, comparisons, etc. and get the Rushmore speed you need.

HTH
Bill
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform