Re: Question on Excel to iSeries PF transfer - dates

[thomas burrows <thomas.burrows.1957@xxxxxxxxx>]

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.