Calculate event duration

0
Hi  i want to create a microflow to calculate the duration of an event. in the entity i have start date and end date and i want to make the duration appears automatically, the trick is that i want the microflow to calculate the duration without the weekend days, only the working days are supposed to be counted.  can someone help me with that ? 
asked
3 answers
2

Hello,

 

You can import this module https://marketplace.mendix.com/link/component/116770 and use WorkingDaysIncludingDates or WorkingDaysExcludingDates  java action.

 

WorkingDaysIncludingDates:

Get working days (excluding Saturday and Sunday) using start date and end date (Start and End date will be included in the working days).

WorkingDaysExcludingDates:

Get working days (excluding Saturday and Sunday) using start date and end date (Start and End date will not be included in the working days).

 

Hope it helps!

answered
0

You can use based on the start and end dates in the entity. Loop through each day excluding weekends, and display or store the working days as the duration.

answered
0

You are welcome.

answered