Ok found it thanks, add_months()
"Roger Smith" <rsmith22_at_fastmail.net> wrote in message
news:7vhlb.30689$At.26781_at_edtnps84...
> That worked perfectly, how do you increment months to a date.
>
> select (LastDate + [5 months]) as DueDate
> from....
>
> I appreciate the help.
>
> "J Alex" <nospam_at_nospamx.info> wrote in message
> news:9Cglb.49022$mp1.5911_at_nwrddc02.gnilink.net...
> >
> > "Roger Smith" <rsmith22_at_fastmail.net> wrote
> > > I need to physicaly change a date to the first of every month ex:
> > >
> > > 12/31/2000 to 12/1/2000 and so on
> > >
> > > select RealDate, (Changed RealDate) as NewDate
> > > from ...
> > >
> > SELECT TRUNC(date_item,'MONTH') from table_name;
> >
> >
>
>
Received on Tue Oct 21 2003 - 16:30:27 CDT
