The most reliable technique is to pass in the date as a parameter of type
.AsDate or .AsDateTime
-----Original Message-----
From: Scott Cree <[EMAIL PROTECTED]>
To: Multiple recipients of list database <[EMAIL PROTECTED]>
Date: Friday, 19 May 2000 11:28
Subject: RE: [DUG-DB]: Dates in SQL/Access
>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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
