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