Article View: borland.public.cppbuilder.database.ado
Article #2613Re: Searching Access table by Date?
From: Ivo Karindi
Date: Thu, 24 Apr 2003 07:26
Date: Thu, 24 Apr 2003 07:26
15 lines
1423 bytes
1423 bytes
Didn't get around to trying this out until just recently, but this works flawlessly. Thanks for the help! Ivo Karindi "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message news:3e97bd39$1@newsgroups.borland.com... > Select * from [TableName] > where [DateColumn] = #03/28/2003# > > or Jet understands much VBScript functions > > Select * from [TableName] > where [DateColumn] = DateSerial(2003, 03, 28)
Technical Details
Message-ID:
<3ea7919b@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mailReferences:
<3e971c16$1@newsgroups.borland.com> <3e97bd39$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,f3b9f68c64c88857 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-04-24 00:36:10 PST Reply-To: "Ivo Karindi" <solk@ieslc.com> From: "Ivo Karindi" <solk@ieslc.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3e971c16$1@newsgroups.borland.com> <3e97bd39$1@newsgroups.borland.com> Subject: Re: Searching Access table by Date? Date: Thu, 24 Apr 2003 10:26:12 +0300 Lines: 17 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 213.35.136.182 Message-ID: <3ea7919b@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1051169179 213.35.136.182 (24 Apr 2003 00:26:19 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail