|
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. |
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.