Dear Expert,
I am working on the adhoc query and would like to generate the total number of payroll days taken by a particular employee.
E.g. Employee A has 4 leave record in Nov 2011
14-Nov, 16, Nov, 23 Nov, 25 Nov
When I select the reporting period between 1-Nov-2011 to 30-Nov-2011, the total payroll days generated by the adhoc query is only 1. I am not sure why. Please help
Best Regards,
WF