Schedule Extract using Fast Formula
Summary:
Hi All,
We have a requirement to submit the extract at 3 different times (11 AM UTC, 5PM UTC, 11 PM UTC), for this i have created a Flow schedule fast formula with below code. Formula which I have written is running for 5AM UTC,11 AM UTC, 5PM UTC, 11 PM UTC.
can anyone suggest what is the mistake in the below code.
INPUTS ARE SUBMISSION_DATE(DATE), SCHEDULED_DATE(DATE)
SCH_TIME = TO_NUMBER(TO_CHAR(SCHEDULED_DATE, 'HH24'))
SCH_DAY = GET_DATE_DAY_OF_WEEK(SCHEDULED_DATE)
SCH_DATE = TRUNC(SCHEDULED_DATE)
NEXT_SCHEDULED_DATE = ADD_DAYS(SCHEDULED_DATE,0.25)
IF(SCH_TIME = 05) THEN
0