Re: Question on Excel to iSeries PF transfer - dates

Yes I have the fields configured correctly. Have attached a word document
showing all my steps. Including the part about doing the ADDIN to the Excel
from Client access. See page twenty seven of document.




On Mon, Apr 23, 2012 at 12:33 PM, Jerry C. Adams <midrange@xxxxxxxx>
wrote:

Are the dates a date data type? Or a numeric/decimal data type?

Jerry C. Adams
IBM i Programmer/Analyst
You have a chip on your tooth, your Adam's apple sticks out too far, and
you
talk too slow. -Universal Pictures executive to Clint Eastwood
--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of thomas burrows
Sent: Monday, April 23, 2012 12:27 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Question on Excel to iSeries PF transfer - dates

Having some problems getting my dates to come across correctly on an

Excel

to iSeries transfer. Where the iSeries connector button has been

installed

on the EXCEL spreadsheet. i.e. There is a DLL that has to be moved to the
correct folder.

Anyway I am getting a number that appears to be something like the number
of
days from some point in time. Not getting iSeries dates.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.