On 2/22/2012 7:12 AM, Michael Savage wrote:
> Save the date format... change it to ymd... import... change it back. ie
> cdFormat=set('Date')
> set date to ymd
> *- do import here
> set date to&cdFormat
>
> Should work.
> Mike
>
> On 21/02/2012 7:36 PM, MB Software Solutions, LLC wrote:
>> I've got a text file I need to import.  It's format is YYYY-MM-DD
>> HH:MM:SS.  When I do APPEND FROM Test.txt TYPE DELIMITED, it fails to
>> bring in the date.  (VFP9SP2)
>>


Hi Mike,

That worked!  I just had to SET CENTURY ON and it worked.  Thanks!

--Mike


-- 
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to