Hi Community,
I'm having some trouble in creating a condition for a FF.
We need a 5 day notice period prior to the absence start date.
e.g. I want to subit an absence today for tomorrow->not possible
I submit an absence today(11/10/22) for the 16/10/22->possible
I tried using this:
( l_start_date BETWEEN l_sysdate AND l_sysdate +5)
This:
TO_DATE(l_start_date,'YYYYMMDD') > l_sysdate AND TO_DATE(l_start_date,'YYYYMMDD') <= (l_sysdate+5)
Or This:
DAYS_BETWEEN (l_sysdate, l_start_date) <= 5
But when compiling I have a data type inconsistency between l_start_date and l_sys_date.
These are defined as follows:
l_start_date = TO_DATE(TO_CHAR(iv_start_date,'YYYY')||'-01-01','YYYY-MM-DD')
l_sysdate = TO_DATE(GLOBAL_PAY_INTERFACE_EXTRACTION_DATE,'yyyymmdd')
Can anyone help with the data formatting?
Thank you very much,
Alberto