Re: Flipping dates in Excel spreadsheet

[Ken.Slaugh@xxxxxxxxxx]

Dim dDate as Date
     dDate = cDate(mid$(CYYMMDD, 4, 2) & "/" & right$(CYYMMDD, 2) & "/" &
mid$(CYYMMDD, 2, 2))


Ken Slaugh  (707) 795-1512 x118
Chouinard & Myhre, Inc.
AS/400 Professional Administrator/MSE
Client Access Specialist
http://www.cm-inc.com/


                                                                                
                   
                    "Shrader, Patrick"                                          
                   
                    <pshrader@wkep.com>        To:     Midrange Mail List       
                   
                    Sent by:                   <MIDRANGE-L@midrange.com>        
                   
                    owner-midrange-l@mi        cc:                              
                   
                    drange.com                 Subject:     Flipping dates in 
Excel spreadsheet    
                                                                                
                   
                                                                                
                   
                    07/17/00 11:39 AM                                           
                   
                    Please respond to                                           
                   
                    MIDRANGE-L                                                  
                   
                                                                                
                   
                                                                                
                   



Has anyone created a slick formula to convert a date in CYYMMDD to MMDDYY
in
an Excel spreadsheet? I have created a number of spreadsheets that use ODBC
to connect to legacy files. These applications use the old date (7,0)
format
and are not date fields. However, I need to manipulate the information in
Excel like a date. So, if you have a formula or macro that will flip the
date, I would be most appreciative.

Thanks in advance,

Patrick Shrader

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---