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

How to make comparison between dates in FF

Summary:


Content (please ensure you mask any confidential information):

Hello experts,

we built the below FF. However it seems not working the highlighted condition in bold, namely

ELIG_EP_2<= '01/01/2025' .

ELIG_EP_2 is retrieved from a value set returning a date as text (TO_CHAR). If this date is lower than

'01/01/2025' than the employee is eligible otherwise is not.

L_ASG_ID = get_context(HR_ASSIGNMENT_ID, -1)
L_PERSON_ID = get_context(person_id, -1)

ELIG_EP_0 =' '
ELIG_EP_1 =' '
ELIG_EP_2 =' '

ELIGIBLE = 'N'
l_asg_id_char=TO_CHAR(L_ASG_ID)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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