Question

daysBetween - for work days?

0

Does anyone know if it’s possible to calculate the number of working days between two dates?

asked 2021-09-22

Garion Swann

3 answers

2

Have a look at the WorkdaysBetween java action in the ApprontoCommon module in the marketplace:

https://marketplace.mendix.com/link/component/993

I have never used it myself, but it seems to do just what you want.

answered 2021-09-22

Edwin van Elk

1

It must be simple with a custom java action.

answered 2021-09-22

Nirmalkumar Thandavamoorthy

Ronald Catersels · Accepted Answer · 2021-09-22

Create a microflow with a variable startingDay and a counter. Check for each day if it is a saturday or sunday by using formatDateTime(startingDay, ‘E’). The E is for Day name in week. You also could use u for Day number of week. If it is a saterday or sunday do not a 1 to the counter. Then use the addDays function to add a day and keep doing this untill you are at the enddate. The counter will tell you how many working days you had.

Regards,

Ronald