It works, thanks!
But I don't understand why, in my SP, I got a conversion error... now
I've tried again, and my source works as it should do...
mydate = in_date - 1;
with in_date defined as date and an input parameter.
thanks again
Marco Menardi

--- In ib-support@yahoogroups.com, "Luiz" <cprmlao@i...> wrote:
> declare variable mydate date;
>
> mydate = cast('2003.01.07' as date) - 1;
>
> Luiz.
>
> ----- Original Message -----
> From: <mmenaz@l...>
> To: <ib-support@yahoogroups.com>
> Sent: Tuesday, January 07, 2003 7:26 PM
> Subject: [ib-support] Subtrac a day from a date: how?
>
>
> > Hi, how can I subtract a day from a date? I mean, I have the date
> > (yyyy-mm-dd format):
> > 2003-01-07
> > and I want to subtract one day so I will have:
> > 2003-01-07
> > (of course, if 2003-02-01 i want 2003-01-31...)
> > I've tried a Delphy like:
> > mydate = start_date_field - 1;
> > but it raises an error...
> > thanks
> > Marco Menardi
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >