i am using 8.2.2
i am trying to set the value of a number field called Lama Bekerja based on the months inputted in Mulai Bekerja accounting the year aswell, i know that using business rules where you can use set value = formula like so...
now when i open it, it doesn't let me do the calculations
can someone explain a method on how to implement this in creatio 8.2.2?
Like
Hello,
As far as we understand, you are referring to the fact that the "Mulai Bekerja" field is not available for selection in the formula setup.
This is most likely because Creatio currently supports only numeric fields in business rule calculations. Date fields, such as "Mulai Bekerja," are not supported in this context.
Please let us know if you'd like assistance implementing this logic using a business process instead.
Hello,
As far as we understand, you are referring to the fact that the "Mulai Bekerja" field is not available for selection in the formula setup.
This is most likely because Creatio currently supports only numeric fields in business rule calculations. Date fields, such as "Mulai Bekerja," are not supported in this context.
Please let us know if you'd like assistance implementing this logic using a business process instead.
Valeriia Hromova,
i have already tried using the business process however am unable to find the year function, so i would like some support here
Michael Fernando Handoyo,
Hello,
Thank you for your follow-up.
You're correct — business rules in Creatio do not currently support date fields in formulas. However, when working with business processes, you can calculate the difference between dates using the C# DateTime structure, as described in the documentation:
Also, we have this built-in function that may help you as well:
Substract one number from another, divide it by 30 (if you need months) - here is your result in months (or you can use other math functions from the article)