Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting months to digits
Message
From
08/04/2014 13:49:52
 
 
To
08/04/2014 08:52:31
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01598233
Message ID:
01598288
Views:
55
>>
>>mymonth = 'APR' (or any)
>>WAIT WINDOW CHRtran(mymonth,'JAN,FEB,MAR,APR,MAY,JUN,JUL,AUG,SEP,OCT,NOV,DEC','01,02,03,04,05,06,07,08,09,10,11,12')
>>
>>
>>the above code obviously does not work. What does? thanks, Randy
>
>If you need to do this a lot, I suggest creating a cursor or table to hold the data and using a look-up.
>
>Tamar


i use:
(AT(lcMonth,"JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC ")-1)/4
Peter Cortiel
Previous
Reply
Map
View

Click here to load this message in the networking platform