declare variable mydate date;

mydate = cast('2003.01.07' as date) - 1;

Luiz.

----- Original Message -----
From: <mmenaz@...>
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/
>
>
>