Date:         Wed, 16 Feb 2000 13:26:22 +0100
Reply-To:     detecsm_hellriegelg@WESTLB.DE
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gehard Hellriegel <detecsm_hellriegelg@WESTLB.DE>
Subject:      Re: Reading dates from Excel97 (DDE)
Content-type: text/plain; charset=us-ascii

not tried, but the EXCEL dates seem to be something like DDMMYY8. or MMDDYY8.
Perhaps you should try that...








Neil White <rosandneil-neil@POWERUP.COM.AU> on 16.02.2000 13:17:27

Bitte antworten an neil.white@bigfoot.com

An:   SAS-L@LISTSERV.UGA.EDU
Kopie:     (Blindkopie: DeTeCSM HellriegelG/D/ExternalStaff/WLB)
Thema:    Reading dates from Excel97 (DDE)



How do I read dates using DDE from an Excel 97 worksheet.

I can read other types, but all I get is invalid data when I try to read
a date.

The dates are Excel date format.  I gather that the informat is
datetime18.  but this doesn't seem to help

any thoughts, code examples...


Ta

Neil

Dr Neil White
CRC Tropical Plant Protection
The University of Queensland
Australia
n.white@tpp.uq.edu.au
*****************************





      Mit freundlichen Gruessen


      DeTeCSM, Gerhard Hellriegel

      WestLB
      Abteilung: 001-80622
      Aderstr. 22
      D - 40217 Duesseldorf
      Tel.: +49211 826 6173
      Fax: +49211 826 5393