Can anyone advise how to get IFS report/SQL to calculate the number of days sick leave days in a specific month e.g. November, when the Absence may be registered over two months as one occurrence /absence ID.
Example:
3 days in November (last the days of month - M/T/W)
2 days in December (first day of Month T/F)
One occurrence of 5 working days
I would like to report 3 days in November and 2 days in December
If I understand correctly, you want split the absence by the months? If this is the case you have the absence Type Divide function call MNTH Divides an absence at the end of a month, with the parameters 1: 1 - on, 0 - off; 2: hourly division handling 1 - on, 0 - off.
Hi Les,
Thank you, I will look at this option with the team, who will probably understand this better than I do. I will let you know how I get on.
Thanks
Trudy
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.