For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to determine Rate Start Date within 'Rate Value Calculation' fast formula
Summary:
How to find Rate start date (DBI/SQL) of a plan within 'Rate Value Calculation' fast formula. We need rate start date to identify the remaining payroll periods and then split the rate accordingly. I tried to use the DBI BEN_EXT_HIST_ECR_RT_STRT_DT_DN , but it is not fetching the date consistently.
Content (please ensure you mask any confidential information):
How to find Rate start date (DBI/SQL) of a plan within 'Rate Value Calculation' fast formula. We need rate start date to identify the remaining payroll periods and then split the rate accordingly. I tried to use the DBI BEN_EXT_HIST_ECR_RT_STRT_DT_DN , but it is not fetching the date consistently.