How to calculate annual leave - please advise
-
Hi, I need your advise please.. here is the detail::: The employee contract can be definite (with expiry date) or indefinite (open without expiry date). The employee contract will always have date of join if the contract is definite then employee will have 30 days every year where the year is the period between the date of join and +365 days and the renewal is the same (from the renewal date and +365) if the contract is indefinite then employee will have 30 days every year where the year is the period between the date of join it's every 365 days so the contract has not renewal but the employee will have 30 days annually. for example, if indefinite and date of join is 1 April 2010 then every period from 1 April until 30 March will have 30 days for the employee I want to calculate the leaves for the employee without having to keep a renew table so it will be calculated based on the leave date and the first date of join. hope I explained it well...
Technology News @ www.JassimRahma.com
-
Hi, I need your advise please.. here is the detail::: The employee contract can be definite (with expiry date) or indefinite (open without expiry date). The employee contract will always have date of join if the contract is definite then employee will have 30 days every year where the year is the period between the date of join and +365 days and the renewal is the same (from the renewal date and +365) if the contract is indefinite then employee will have 30 days every year where the year is the period between the date of join it's every 365 days so the contract has not renewal but the employee will have 30 days annually. for example, if indefinite and date of join is 1 April 2010 then every period from 1 April until 30 March will have 30 days for the employee I want to calculate the leaves for the employee without having to keep a renew table so it will be calculated based on the leave date and the first date of join. hope I explained it well...
Technology News @ www.JassimRahma.com
so the data will be just one leave table with from and to indicating the leave period for every leave and the result will be 1 April - 31 March - [Total Taken Leaves] - [Total Remaining Leaves]
Technology News @ www.JassimRahma.com
-
Hi, I need your advise please.. here is the detail::: The employee contract can be definite (with expiry date) or indefinite (open without expiry date). The employee contract will always have date of join if the contract is definite then employee will have 30 days every year where the year is the period between the date of join and +365 days and the renewal is the same (from the renewal date and +365) if the contract is indefinite then employee will have 30 days every year where the year is the period between the date of join it's every 365 days so the contract has not renewal but the employee will have 30 days annually. for example, if indefinite and date of join is 1 April 2010 then every period from 1 April until 30 March will have 30 days for the employee I want to calculate the leaves for the employee without having to keep a renew table so it will be calculated based on the leave date and the first date of join. hope I explained it well...
Technology News @ www.JassimRahma.com