How to calculate leave except saturday and sunday?

0
i calculate total days and subtract from casual leave and sick leave but except saturday sunday how to calculate only working days
asked
3 answers
3

Hi Pranjali,

The following Module  will help you to achieive it 

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

 

answered
0

Hi,

You can use the module in app store:

https://appstore.home.mendix.com/link/app/110117/

Also please find the forum question link below which can help you :

https://forum.mendix.com/link/questions/95794

answered
0

Hello Pranjali Kawale ,

You can also try like this,

>>1, calculate the amount of full weeks you have in the period, and multiply this with 5.
 –   (daysBetween($StartDate,$EndDate) – (daysBetween($StartDate,$EndDate) mod 7) div 7)*5

>>2 find out which days are in your remainder (because you could have not full weeks)
 – Create a variable with the number of remainder days: daysBetween($StartDate,$EndDate) mod 7. 

answered