• Subject: Re: excel to 400 transfer
  • From: DonW400@xxxxxxx
  • Date: Wed, 01 Nov 2000 18:59:57 EST

   For at least one version of Excel to which I transfered AS/400 data, the 
date '01-01-0001' was not valid.  The earliest valid date was '01-01-0100'.
   I don't know if this is a problem with the version you are using, but you 
might try a quick test by changing any instances of 01-01-0001.
   And if anyone happens to know why 01-01-0100 was the earliest date 
supported, I'd be interested in hearing about it.

Hope this helps,
Don Whittaker

In a message dated Tue, 31 Oct 2000  2:38:34 PM Eastern Standard Time, 
"Lawrence Roberts" <robertslaw@hotmail.com> writes:
<< Having a problem sending an Excel file up to the '400. The transfer 
is failing with an SQL errid of 0180, invalid date or timestamp. The 
spreadsheet field is defined as an Excel date format and the '400 field is 
an "L" type date definition. Any help would be appreciated.

| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].