Good day developers,
I am developing a small leave database which will store all the leaves taken by an employee. I am currently busy with sick leave but finding difficulties. I would like to have a script which checks every month for sick leave days taken by an employee. It will then subtract the sick leaves taken from 30 sick leaves which are given to an employee for 3 years. I would like to take remaining sick leave days from the previous month to the next month until the 3 year cycle ends.
Could you guys please show me the right direction because I am still new to filemaker.