Re: How to use IBTable'filter property with date datatype ?

Article View: borland.public.interbase.opensource

Article #5486

Back to borland.public.interbase.opensource Previous Next

#5486

From: xuan vinh
Date: Mon, 02 Apr 2001 09:19

20 lines
1635 bytes

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: <3ac8360d$1_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!128.230.129.106!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!207.105.83.65

References: <3ac7f561$1_1@dnews> <3ac826ba$1_2@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 01:24:34 PST
From: "xuan vinh" <xuanvinh10@hotmail.com>
Sender: "xuan vinh" <xuanvinh10@hotmail.com>
Reply-To: "xuan vinh" <xuanvinh10@hotmail.com>
Subject: Re: How to use IBTable'filter property with date datatype ?
Newsgroups: borland.public.interbase.opensource
X-User-Info: 202.167.119.146 202.167.119.146    
References: <3ac7f561$1_1@dnews>  <3ac826ba$1_2@dnews> 
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3ac8360d$1_1@dnews>
Date: 2 Apr 2001 01:19:25 -0800
X-Trace: 2 Apr 2001 01:19:25 -0800, 207.105.83.65
Lines: 21
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!128.230.129.106!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!207.105.83.65

Reply to Parent Message