Question

Need to use a caluculated field value in process formula

Hello,

 

As displayed in the capture below, I added the "Number of nights" calculated field which display the number of nights between two dates (chek-in date) and (chack-out date) by adding an attribute "UsrNumberOfDaysOrMonths" and a method handler to calculate the value and binding this attribute to the view model column.

My question is: Is there any way to use this attribute (Calculated field value) in process formula?

 

 

Thank you.

Like 0

Like

2 comments

For the number of days between two dates, you could use a formula in the process that looks something like this:

([EndDateField] - [StartDateField]).TotalDays

Ryan 

Ryan Farley,



Thanks for simplifying it!



We can use the OOTB "Business rule" by using the date difference function. This directly gets reflected in client side (instead BPs server code execution and refreshing the client page).

 

 

BR,

Bhoobalan Palanivelu.

Show all comments