How to get day wise time card data into Accrual formula
Summary
How to get day wise time card data into Accrual formulaContent
Hi All,
As part of my custom compensatory off accrual plan, I am trying to get the holiday worked data from the time card.
Here I am using GET_CALCULATED_HOURS function to get the data from time card. In this start date and end date parameters are period start and end date which is weekly repeating time period.
I have a condition that if an employee worked >=9 hrs howmany hours it may be on that particular day, it should accrue 8 hrs. But as I am not able to get the timecard data day wise, not able to validate the same. Whatever hours returning from the above function is for that week holiday worked. For example: In a week there are 2 public holidays and employee has worked on both the public holidays those total hours are returning by the above function.