Hello

I have a quite easy formula to build but I get stuck

I have a date field. I have a number field (number of months)

I am trying to add the number of month to the date field to get a new date

For that I have rebuild date thank to month, year, day of date field and date function

Issue I have for instance is : 01/30/09 + 1 month -> date (2009,02,30) which gives an error

Is there a way to say : if (date(2009,02,30) is an error) then .... ?

Is there another way to build my calculated date ?

Thanks for your help

Regards

Hello

I have a quite easy formula to build but I get stuck

I have a date field. I have a number field (number of months)

I am trying to add the number of month to the date field to get a new date

For that I have rebuild date thank to month, year, day of date field and date function

Issue I have for instance is : 01/30/09 + 1 month -> date (2009,02,30) which gives an error

Is there a way to say : if (date(2009,02,30) is an error) then .... ?

Is there another way to build my calculated date ?

Thanks for your help

Regards