Date:         Tue, 31 Jul 2001 10:08:29 +0300
Reply-To:     Kamal_ahmed@alfalak.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Osama Keshtah <osama_keshtah@ALFALAK.COM>
Subject:      ERROR in DATE column during acceess to SQL (in JMP)
Content-Type: text/plain; charset="iso-8859-1"

Hello,

I Try to use access to SQL data through ODBC, and I got data successfully
form SQL server except date column.
All of date records contains one wrong value 01/01/1904
The format for date in SQL is mm/dd/yyyy and length is 8
How we can get this date column with correct value from SQL through ODBC

Note: When save SQL data  as excel file and try to open this excel file.
Date column  was coming as correct value.
_________________________________
Osama Keshtah
Software Consultant
SAS Division, ALFALAK,
SAUDI ARABIA
E-mail: osama_keshtah@alfalak.com
Tel 966 (3) 882-9996 Ext 193 - Fax 966 (3) 882-2156
__________________________________