Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting to Date
Message
 
 
To
20/09/2001 09:53:45
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00558696
Message ID:
00558709
Views:
14
>I am trying to convert these strings to a date - tried for 022301
>date(val("20"+ right(prinpxdate,2)),val(left(prinpxdate,2)),val(substr(prinpxdate,3,2)))
? Ctod((Transform("022301", "@R 99/99/9999")))
>and for 03312001 - date(val(right(to),4)),val(left(to,2)), val(substr(to,3,2)))
? Ctod((Transform("03312001", "@R 99/99/9999")))
As you can see the same code will convert both. It'll work if SET STRICTDATE is set to 1 or lower.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform