Add 1 day to a date in a FF

Summary

we need to add 1 day to a dare

Content

Hello,

 

we need to add one day to the following FF outcome:

DEFAULT FOR DATA_ELEMENTS IS EMPTY_TEXT_TEXT

INPUTS ARE DATA_ELEMENTS (TEXT_TEXT)
l_eff_date (date)= TO_DATE(SUBSTR(GET_PARAMETER_VALUE('effective_date'),1,10))

i=1
rule_value  = ' '
l_person_id = -1

IF DATA_ELEMENTS.EXISTS('PERSON_ID') THEN
(
   l_person_id = TO_NUMBER(DATA_ELEMENTS['PERSON_ID'])
   rule_value = GET_VALUE_SET('XXHR_REHIRE_DATE','|=P_PERSON_ID='''||to_char(l_person_id)||'''')
   rule_value = (rule_value + interval '1' day)