RE: Upload Date Data from Excel

Jim, Alan

I participated in a thread discussing where there was a bug in the Excel
date calculation routine, about a year ago.  Don't recall even what list it
was on.. maybe RPG-L.  I think there was discussion on the calculations
Excel uses.  Don't recall it as complicated...


jt

| -----Original Message-----
| From: midrange-l-admin@midrange.com
| [mailto:midrange-l-admin@midrange.com]On Behalf Of Alan Novick
| Sent: Tuesday, December 11, 2001 4:10 PM
| To: midrange-l@midrange.com
| Subject: Re: Upload Date Data from Excel
|
|
| Wow Jim that was a very creative solution.  It would be a bit
| cumbersome in
| my situation.  Our warehouse vendor is sending us a file of open
| orders and
| I want to compare for discrepancies with our order files.  Several of the
| columns they are sending are date fields.  I guess there must be
| documentation on how to convert that Excel number to a date but I
| was hoping
| IBM or someone else had done it for me :)
|
| Alan Novick
| Pressman Toy Corporation
| New Brunswick, NJ
| ----- Original Message -----
| From: "Jim Damato" <jdamato@dollargeneral.com>
| To: <midrange-l@midrange.com>
| Sent: Tuesday, December 11, 2001 3:46 PM
| Subject: RE: Upload Date Data from Excel
|
|
| The last time I did this I ended up concatenating the character values of
| the Excel DAY, MONTH, and YEAR functions into another column, and dropping
| the value of that string into another.  I just searched, but I don't still
| have the spreadsheet.  It took a long time to debug, but I had given up on
| dealing with the integer value behind the date cells, and couldn't find an
| easy way to translate dates into values while retaining the format.
|
| I'm sure there's a better way...
|
| -Jim
|
| James P. Damato
| Manager - Technical Administration
| Dollar General Corporation
| <mailto:jdamato@dollargeneral.com>
|
|
| -----Original Message-----
| From: Alan Novick [mailto:mida@pressmantoy.com]
| Sent: Tuesday, December 11, 2001 1:37 PM
| To: MidRange-L
| Subject: Upload Date Data from Excel
|
|
| I have an Excel spreadsheet with columns that are dates.  When I upload to
| the AS/400 it becomes a number.  Anyone know how to bring the date up?
|
| Thanks,
| Alan Novick
| Pressman Toy Corporation
| New Brunswick, NJ
|
|
| _______________________________________________
| This is the Midrange Systems Technical Discussion (MIDRANGE-L)
| mailing list
| To post a message email: MIDRANGE-L@midrange.com
| To subscribe, unsubscribe, or change list options,
| visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
| or email: MIDRANGE-L-request@midrange.com
| 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@midrange.com
| To subscribe, unsubscribe, or change list options,
| visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
| or email: MIDRANGE-L-request@midrange.com
| 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@midrange.com
| To subscribe, unsubscribe, or change list options,
| visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
| or email: MIDRANGE-L-request@midrange.com
| Before posting, please take a moment to review the archives
| at http://archive.midrange.com/midrange-l.
|