Need inputs to get the number of Payrolls between the Period start date and period end date
Content
Hi All,
We have a requirement to find the number of payrolls in between the period start date and period end date through FF.
Ex: Period start date :01-Aug-2019
Period End Date:31-Aug-2019
Payroll Name:XYZBIWeekly.
Expected Output:3
To achieve this requirement we are unable to find the DBI's from the FF so that we developed below SQL query to be used in a value set and call from FF but we are unable to use aggregate functions in value set.
Any inputs to achieve this requirement from DBI's in FF or through Value set.
SELECT a.abc
FROM