Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create a STOD command/function?
Message
From
06/05/2002 09:50:32
 
 
To
03/05/2002 20:36:01
Bill Totten
William Totten & Associates, Inc.
Indiana, United States
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00651378
Message ID:
00653038
Views:
20
>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

Bill, that seems to be the gist of what everyone is telling me. The "1" idea is definitely worth pursuing. I'll take a look but I'm not sure that the CTOD(MMDDYYYY) function for the DTOC will return properly. I will check, though.
TANX
Pete
Peter Adams
FoxPro Programmer
Compu-Mail

Heisenberg was probably right...
Previous
Reply
Map
View

Click here to load this message in the networking platform