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,
Like
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
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
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
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