How to Schedule the HCM Extract For multiple Times a day and passing Effective date as Sysdate

Summary:

We have a Requirement to Schedule the HCM Extract For multiple Times a day and passing Effective date as Sysdate,

We have Developed the Fast Formula to Run the Extract for Every 4 Hours which is working fine and we have edited the parameter in Refine Extracts and made it as Post SQL Bind and basis value as (Select sysdate from dual) , But problem is the run which is scheduled for next day on the current day is return the sysdate as parameter value.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):