Fetching Rates based on a Date Worked in Fusion Payroll

Summary:

Fetching Rates based on a Date Worked in Fusion Payroll

Content (required):

Hi,

I hope someone can confirm the following for me as I have been told it is not possible:

Fusion Payroll does not appear to have the capability of fetching Rates which are applicable at a given date; e.g. an elements 'Date Worked' input value.  Apparently, the CALL_CALC_VALUE function does not allow us to pass the 'Date Worked' input value and it assumes the date we want to fetch a rate at is the Effective_Start_Date of the element rather than the input date value ('Date Worked'); and I believe there is no other function which would provide us this facility (even changing the context in the formula apparently doesn't work).