Article View: borland.public.interbase.opensource
Article #5487Re: How to use IBTable'filter property with date datatype ?
From: Dipsy
Date: Mon, 02 Apr 2001 10:13
Date: Mon, 02 Apr 2001 10:13
25 lines
1853 bytes
1853 bytes
Sorry about the where. Of course it has to be omitted in the filter property. The rest was (as written) just an example. "xuan vinh" <xuanvinh10@hotmail.com> schrieb im Newsbeitrag news:3ac8360d$1_1@dnews... > > your code is incorrect, there no "where" keyword permitted(DateField >= "3/1/2001").Other thing, I only want to have '=' not '>='. > > "Dipsy" <-> wrote: > >You will have to write it in the native Interbase format that may differ from > >the current system settings. > > > >For example: where DateField >= "3/1/2001" > > > >The order of the date components is always the stupid ;-) > >US format month/day/year. It would be a good idea to > >have a conversion function in IBX for that purpose. > > > > > >"xuan vinh" <xuanvinh10@hotmail.com> schrieb im Newsbeitrag news:3ac7f561$1_1@dnews... > >> > >> I use IBtable,but do not know how to filter dataset via date datatype field ( Example, I only want to display records that have > >date field value 01/01/2001),someone can help me? > > > > >
Technical Details
Message-ID:
<3ac85094_1@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!62.153.172.147References:
<3ac7f561$1_1@dnews> <3ac826ba$1_2@dnews> <3ac8360d$1_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 106772,723daccb62742878 X-Google-Attributes: gid106772,public X-Google-ArrivalTime: 2001-04-02 03:26:07 PST From: "Dipsy" <-> Newsgroups: borland.public.interbase.opensource References: <3ac7f561$1_1@dnews> <3ac826ba$1_2@dnews> <3ac8360d$1_1@dnews> Subject: Re: How to use IBTable'filter property with date datatype ? Date: Mon, 2 Apr 2001 12:13:47 +0200 Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 NNTP-Posting-Host: 62.153.172.147 Message-ID: <3ac85094_1@dnews> X-Trace: 2 Apr 2001 03:12:36 -0800, 62.153.172.147 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!62.153.172.147