|
On 19 Maio, 10:19, RolandRB <rolandbe...@hotmail.com> wrote:
> On May 19, 11:15 am, Nanita <susana.urb...@gmail.com> wrote:
>
>
>
> > Hi there,
>
> > I'me havind some trouble summing some dates.
>
> > I have a table with a column with Begin_Date and another colunm with
> > Maturity_Lenght.
>
> > I need to create another column with the End_Date, by adding the
> > Maturity_Lenght to the Begin_Date.
>
> > Begin_Date Maturity_Lenght (days) End_Date
>
> > 02-05-2008 1
> > 02-05-2008
> > 05-05-2008
> > 7 .....
>
> > How can I do that?
>
> > Thank you so much.
>
> End_Date = Begin_Date + Maturity_Length;
>
> You also have to supply a date format to End_Date .
Thank you so much for your help.
And if I want to sum months. For exemple, if I add 1 month to
02-05-2008 the end date will be 02-06-2008, and if I do it to
02-06-2008 the end date will be 02-07-2008. Don't matter the number
days in each month.
|
