Addmonth | Community Creatio

Question

09:54 Feb 02, 2021

Hello,

Please advise, I'm working first time with Addmonth function in Business Rules Formula section. What parameters I need to use?

I would like to calculate end date :

=Addmonth (start date ( date) , number of installments ( integer)) I'm able to save it but later on an error appears:

Formula error: invalid expression in end date field.

thank you,

4 comments

Dean Parrett

01:17 Feb 03, 2021

Dear Patrycja,

Could you please clarify what is your business task? What exactly do you want to calculate with the process an what is your expected result?

Thank you.

Regards,

Dean

Ewelina Szmidt

17:23 Feb 03, 2021

Hi!

We would like to calculate the contract End date.

The user completes the Start Date (date) and Duration (months).

What parameters should be used?

Unfortunately this formula doesn't work:

=Addmonth (Start Date ( date) , Duration ( integer))

Regards,

Ewelina

Ewelina Szmidt

20:24 Feb 03, 2021

Hi Dean,

We would like to calculate the contract End date.

The user completes the Start Date (date) and Duration (months).

What parameters should be used?

Unfortunately this formula doesn't work:

=Addmonth (Start Date ( date) , Duration ( integer))

Regards,

Ewelina

Dean Parrett

16:31 Feb 17, 2021

Dear Ewelina,

The formula AddMonth([Start date],[Duration]) will work, but it will throw the error when creating the record. Calculation will be preformed fine on the existing record.

This bug is already reported and will be fixed in the nearest future version releases.

Regards,

Dean

Show all comments

Subscribe to Addmonth