How to get element entry value in specific date in fast formula?
Hi,
We have requirements which need to get element entry value DB in specific date in formula of Oracle Payroll type, I tried to change context to be as bellow
DEFAULT FOR MOBILE_ALLOWANCE_AMOUNT_ENTRY_VALUE IS 0
l_eff_date = to_date ('10-07-2021','DD-MM-YYYY')
CHANGE_CONTEXTS (DATE_EARNED = l_eff_date)
(
L_VALUE = MOBILE_ALLOWANCE_AMOUNT_ENTRY_VALUE
)
and tried also below
CHANGE_CONTEXTS (EFFECTIVE_DATE = l_eff_date)
(
L_VALUE = MOBILE_ALLOWANCE_AMOUNT_ENTRY_VALUE
)
but it is taking period all the time please advise.
Regards
Tagged:
0