You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Add 1 day to a date in a FF

Accepted answer
15
Views
4
Comments
edited Mar 1, 2021 2:28PM in HCM Integrations 4 comments

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)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!