On 4 Jan 2002, at 22:00, didiergm wrote:

> Works perfect,
>
> thanks
> Didier
>
> --- In ib-support@y..., "Roberto de Amorim" <rbamorim@i...> wrote:
> > > I need to do some ageing calculations on finance transactions, and
> > > have got several questions:
> > >
> > > A: How can I calculate the dateparts of a date (day, month, year). I
> >
> > Heve you been tested the "EXTRACT" command??
> > try it:
> >
> > SELECT EXTRACT( MONTH FROM <table.date_field> AS MONTH_OF_DATE FROM
> <TABLE>

How about Incrementing the month ? Is there any way to do that?

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz