Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace Date field with Character value
Message
From
04/10/1999 13:41:14
 
 
To
04/10/1999 13:17:54
Jolene Dicks
Human Resources Development Canada
St. John's, Newfoundland, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00272313
Message ID:
00272395
Views:
31
>This is my code below:
>
>Tmp="19650824"
>a=Right(Tmp,4)
>b=Left(Tmp,2)
>DateString=(Left(Tmp,4)+"\"+b+"\"+Right(Tmp,2))
>
>Tmp2=CTOD(DateString)
>Replace Client.DOB with Tmp2
>
>It just isn't working for me. It is replace client.dob with {\\}!! Any suggestions?

In addition to what George has said, don't you really mean:

b=LEFT(a,2)

???

Otherwise you're creating a date string like "1965/19/24" which is invalid.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform