Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting a date from .txt file or variable
Message
From
07/07/2008 12:44:43
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01329441
Message ID:
01329474
Views:
13
>>
>>lcDate='04/07/2008 1054AC PRESIDENTE EPITACIO - PRESIDENTE EPITACIO/SPConferi'
>>?Date(Val(substr(lcDate,7,4)),Val(left(lcDate,2)),Val(Substr(lcDate,4,2)))
>
>I also prefer DATE function when I should convert something to date but if you have something wrong in that sting you will get error, with CTOD() you will get en empty date.

That's a good point. On the other hand, your code is independent of the Set Date format. Maybe a combination of Try-Endtry and Date() would be best?
Previous
Reply
Map
View

Click here to load this message in the networking platform