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

Article View: borland.public.interbase.opensource

Article #5485

Back to borland.public.interbase.opensource Previous Next

#5485

From: Dipsy
Date: Mon, 02 Apr 2001 07:15

14 lines
1381 bytes

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: <3ac826ba$1_2@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.147

References: <3ac7f561$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 00:40:02 PST
From: "Dipsy" <->
Newsgroups: borland.public.interbase.opensource
References: <3ac7f561$1_1@dnews>
Subject: Re: How to use IBTable'filter property with date datatype ?
Date: Mon, 2 Apr 2001 09:15:19 +0200
Lines: 16
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: <3ac826ba$1_2@dnews>
X-Trace: 2 Apr 2001 00:14:02 -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

Reply to Parent Message