Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cmonth
Message
From
23/06/1999 16:53:33
 
 
To
23/06/1999 16:49:27
Dovi Gilberd
Dovtware Consulting Inc
Miami, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Cmonth
Miscellaneous
Thread ID:
00233028
Message ID:
00233199
Views:
38
>this is my actual line of code
>
>my field is a character field and it comes from a harris PBX like this
>990501
>so if i apply this line of code to 990501 like such
>
>substr(view1.strtdate,3,2) + "/" + substr(view1.strtdate,5,2) + "/" + substr(view1.strtdate,1,2)
>
>i get 05-01-99
>i need to get May-01-99

Right. So if you do this:

dVar = CTOD(substr(view1.strtdate,3,2) + "/" + substr(view1.strtdate,5,2) + "/" + substr(view1.strtdate,1,2))
YourNewString = CMONTH(dVar)+'-'+substr(view1.strtdate,5,2)+'-'+substr(view1.strtdate,1,2)

You should get:

May-01-99 in the variable YourNewString.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform