Date sent:              Fri, 27 Apr 2001 15:55:21 +0100 (BST)
From:                   Maria Quinn <[EMAIL PROTECTED]>
To:                     "Sterin, Ilya" <[EMAIL PROTECTED]>
Copies to:              "'mi email '" <[EMAIL PROTECTED]>,
        "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
Subject:                RE: How to add Date records to MS ACCESS

> On Fri, 27 Apr 2001, Sterin, Ilya wrote: 
> 
> > I believe in access you must enter date as "#02/03/1999#"
> > 
> > Also your query is totally wrong, it's not  
> > "INSERT $date INTO table1
> > VALUES($date)"
> > 
> > but rather 
> > 
> > "insert into table 1 date values ($date) 
> 
> Shouldn't that be:
> 
> insert into table1 values ($date)
> 
> I'm not familiar with Access SQL syntax, so I may be wrong.
> 
> Maria

"insert into table1 date values ($date)"

is probably closest to what was meant by mi email. Ilya's version 
contained just a typo (the space between 'table' and '1'). BTW, what 
about storing your dates as long integers and leaving the conversion 
from input and to formatted output to the application level ?

Bodo
[EMAIL PROTECTED]
Dr. med. Bodo Eing
Institut fuer Medizinische Mikrobiologie
Klinische Virologie
v.-Stauffenbergstr. 36
48151 Muenster
Germany

Phone: ++49 251 7793 111 Fax: ++49 251 7793-104

Reply via email to