Re: excel to 400 transfer

[DonW400@xxxxxxx]

   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 
request 
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
+---