Re: Excel data transfer add-in DATE fields

["David A Parnin" <daparnin@xxxxxxxxxxxxxxxxxx>]

If the month, day, and year start as numeric fields and you want the result
to be numeric you could just "do the math".  This is if the date is
xx-xx-xxxx.

DATE = (MONTH * 10000000) + (DAY * 100000) + YEAR


Dave Parnin
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxxxxxx





                                                                                
                              
                      Mail List                                                 
                              
                      <maillist@xxxxxxx        To:       
MIDRANGE-L@xxxxxxxxxxxx@SMTP@xxx                     
                      ware.com>                cc:                              
                              
                                               Subject:  Excel data transfer 
add-in DATE fields               
                      06/23/2003 01:07                                          
                              
                      PM                                                        
                              
                      Please respond to                                         
                              
                      Midrange Systems                                          
                              
                      Technical                                                 
                              
                      Discussion                                                
                              
                      <midrange-l@xxxxx                                         
                              
                      nge.com>                                                  
                              
                                                                                
                              
                                                                                
                              



Hi All,

I'm using the IBM CAExpress Excel add-in to download some data from an
AS400
to a spreadsheet.  The problem is the file contains separate numeric fields
for a date's month, day and 4-digit year.  In order to get Excel to
recognize this as a date, I have something like this:

select digits(MONTH) || '/' || digits(DAY) || '/' || digits(YEAR) as
DateFld
from Lib/File

but it comes across as a character value.  If I simple edit the cell
containing it without actually changing anything, Excel then recognizes it
as a date.  I could set up a macro do do this, but I'd prefer a solution
that doesn't require extra processing after downloading the data.

tia,
Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 793-4480 fax
909 522-3214 cell


_______________________________________________
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.