Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting SHORT dates to date values
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01129663
Message ID:
01129675
Views:
16
>I have a file where the dates are in dd-MMM-yy format. I thought I'd let SET DATE SHORT handle it for me, but no luck - I just got blanks back.
>
>Even more amusingly, while DTOC(DATE()) shows the date the same way it is in the table, CTOD(DTOC(DATE())) fails the same way the table dates do.
>
>Any thoughts on how to get this to work, or am I just going to have to reformat the dates before converting them?
>
>Thanks.

It (?CTOD(DTOC(DATE()))) only fails for me with SET DATE LONG. Any other setting seems to work. (VFP9/SP1)
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform