Question on Payroll Flow Pattern Effective Date

Summary:

Question on Flow Parameter Binding

Content (please ensure you mask any confidential information):

Hi Experts,

Recently I found the Flow Parameter > Effective Date post SQL binding confusing.

Our sample setup:

Task Sequence is Start Flow > Task1 > End Flow

We tried to use Flow Parameter with the following setup post SQL binding Effective Date to sysdate.

When we ran the flow with May 27 as the Effective Date on June 1 (sysdate), we noticed it was not pulling records from June 1 (if we entered June 1 as Effective Date, the records are pulling correctly). When we dig into the XML file, we saw it is still using May 27. My understanding is that Post SQL Bind doesn't show on front end UI at submission, but should show at XML level once the extract ran.