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:29:04
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01329441
Message ID:
01329463
Views:
12
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)))
>The date is in DD/MM/YY format as text below
>
>I already have the line number
>
>I was thinking about something as:
>
>If line contains "2008" or "2009" or "2010", get the the year
>and also contents at its left side and then convert it to date with ctod ()
>
>Can anybody help me with this line, or is there a more smart solution ?
>
>Thanks
>
>
>
>piece of TXT file
>
>**********************************
>
>04/07/2008 10:54AC PRESIDENTE EPITACIO - PRESIDENTE EPITACIO/SPConferido
>
>******************************************************************************
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform