Formula TEST, line 17, syntax error at character position 1 — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Formula TEST, line 17, syntax error at character position 1

in Payroll and Global Payroll Interface (GPI) 4 comments

Summary:

🧾 Explanation of the Logic and Formula

✅ Objective:

To identify employees whose Work Relationship Start Date (PER_REL_DATE_START) falls on or before the 15th day of any month.

This logic can be used for purposes like:

  • Payroll eligibility
  • Benefits enrollment cutoff
  • Custom reporting group criteria

🧠 Business Logic:

We want to include only those employees who started their work relationship on or before the 15th of the month.

So, for example:

  • If the hire date is April 12 → ✅ include
  • If the hire date is April 25 → ❌ exclude

📝 Explanation of My Setup and Logic

To implement the required business rule, I created

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!