Gerald,

You can access the Interbase list via a mailing list server, where all
posts are mailed to you, and you can reply and/or send your own posts.
This all happens via e-mail, so the firewall don't enter into it...

See http://mers.com/mailman/listinfo/interbase to subscribe.

Vince

gerbreown@... wrote:

>
> Helen,
>
> Thanks for the quick response. I tried BETWEEN and that worked so I
> will just have to specify the FIRST and LAST day of the month and use
> in my WHERE clause.
>
> As for your next response, the firewall at my company does not allow
> me to go to any other newsgroups(ie. MERS) except this one.
>
> Gerald S. Brown
> --- In IBDI@egroups.com, Helen Borrie <helebor@w...> wrote:
> > At 02:13 PM 17-08-00 +0000, you wrote:
> > >Hi All,
> > >
> > >I'm not sure if this is the correct place to post this so if it is
> > >not
> > >then I would appreciate it if I could be pointed to the correct
> place.
> > >
> > >My question is: How do I select records in an IB table where the
> > >month and year of a date field = 8 and 2000 respectivaly.
> > >
> > >I have tried MONTH(field), DATEPART("m", field), EXTRACT MONTH FROM
> > >field and none of these functions work in IB.
> > >
> > >TIA,
> > >
> > >Gerald S. Brown
> >
> > IB doesn't natively support DATEPART. The fastest way to do it
> will
> be by
> > asking for a date range (if that's possible for what you need);
> otherwise,
> > check out the UDF (User-Defined Functions) libraries to see if the
> > functions you want are there. You need to declare the functions to
> your
> > database - check out DECLARE FUNCTION.
> >
> > Helen
> > http://www.interbase2000.org
> > ___________________________________________________
> > "Ask not what your free, open-source database can do for you,
> > but what you can do for your free, open-source database."
> > (J.F.K.)
>
>
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI

--
Vince Duggan
Synectics Software
Inprise C/S Business Partner
South Africa
http://www.synectics.co.za
mailto:vince@...