It should be mm/dd/yyyy if you're doing any sql in Access.
Cheers,
Scott.
-----Original Message-----
From: Derricutt, Mark [mailto:[EMAIL PROTECTED]]
Sent: Friday, 19 May 2000 11:14
To: Multiple recipients of list database
Subject: [DUG-DB]: Dates in SQL/Access
In my app I've been using dd-mmm-yyyy as a date format in my SQL, works
against paradox and sql7, however, I just tried accessing an access DB and
its giving errors about the date format, whats the appropriate format for
dates in sql against access? I can't seem to find anything that it accepts.
--
Mark Derricutt "People in prayer for me, everyone there for me,
ICQ: 1934853 sometimes I feel I should face this alone, my
Wrk: 377-9941 soul exposed... it calm's me to know that I
Fax: 377-9947 won't!" = Dream Theater - Scarred
DDI: 375-3754
Now Playing: <no audio cd present>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
