Where can I get all details on allowed formula systax and possible functions allowed to use For example I was working to extract month & year from date and it was not so easy to understand best function allowed in business process formulas windows.
Formulas are C#. Creatio does have a few built in functions that can be used in formulas, but for the most part, it's a better approach to just think of it as C#. For extracting the month and year from a date, you'd just use C# syntax for Year and Month. For example:
Formulas are C#. Creatio does have a few built in functions that can be used in formulas, but for the most part, it's a better approach to just think of it as C#. For extracting the month and year from a date, you'd just use C# syntax for Year and Month. For example:
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?
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.
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.
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)
