Retrieving Latest Effective Start Date from Employment Assignment Page
We are implementing a Field Value Validation where we need to compare the Action Date with the latest Effective Start Date from the Employment Assignment section.
We have tried using the following fields to retrieve the Effective Start Date:
- $fields.employmentAssignments.EffectiveStartDate
- $fields.employmentWorkerAssignments.EffectiveStartDate
- $fields.employmentWorkerAssignmentHistory.EffectiveStartDate
However, these fields do not appear to return the latest assignment record's Effective Start Date reliably.
📌 Request: Could you please confirm which field should be used to fetch the latest Effective Start Date from the Employment Assignment page, especially when there are multiple records?
Screenshots are attached for reference.
Thanks in advance!