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)