hi,
the case is php with mysql.
coding for the calculation.
e.g. a) an employee has 18 days leave a year...
b) an employee take leave from 3/6/03 to 6/6/03 ( count the duration and the balance of the leave).....
<in my web site exmple>
from date: xx/xx/xx (empty field)
to date : xx/xx/xx (empty field)
duration : <result>
balance : <result>
after insert the ‘ from date ‘ and ‘ to date’, the duration and the balance of leave will automatically show …