CLOCK_DATE records the business date a clocking is assigned to in PeopleXD Workforce Management. If clockings are appearing on the previous day, this is usually caused by overnight shift patterns or your previous day threshold settings. This article explains how CLOCK_DATE works and what you can review to resolve unexpected date assignments.
⚠️ Important: CLOCK_DATE behaviour is expected when shift patterns and threshold settings are designed to support overnight working. Adjusting configuration should always be done in line with payroll rules and organisational definitions of a working day.
What CLOCK_DATE is used for
CLOCK_DATE records the business date a clocking is assigned to, not necessarily the exact time a clocking occurred. The system uses configuration rules to decide whether early hours belong to the current or previous working day.
Why CLOCK_DATE shows the previous day
Early shift start times
When shift patterns include very early start times, particularly around midnight or shortly after, the system may assign those clockings to the previous day.
For example:
A shift starting at 00:30 may still be treated as part of the previous working day depending on configuration.
This ensures shifts that span midnight remain grouped correctly for payroll and reporting.
Previous day threshold setting
PeopleXD Workforce Management uses a previous day threshold to determine when a new working day begins.
If the threshold is set to 03:00:
Any clockings before 03:00 are assigned to the previous day.
Any clockings after 03:00 are assigned to the current day.
This setting is commonly used to align system processing with overnight shifts and operational day boundaries.
Shift pattern alignment
If shift patterns and threshold settings are not aligned, the system may consistently assign clockings to an unexpected date.
This is most likely to occur when:
Shift start times fall before the threshold.
Multiple overnight shift patterns are in use.
Temporary or placeholder patterns are assigned.
Reduce date discrepancies
Review shift pattern design
Ensure shift patterns reflect how your organisation defines a working day. Check:
Start and end times for overnight shifts.
Whether shifts cross midnight.
Consistency across employee groups.
Adjust the previous day threshold
Set the threshold to match operational requirements. For example:
Early morning operations may require a later threshold.
Day-based operations may benefit from an earlier cutoff.
Assign correct patterns in advance
Ensure employees are assigned the correct shift patterns before clockings occur. This reduces the risk of temporary or mismatched pattern rules affecting CLOCK_DATE.
Troubleshoot CLOCK_DATE issues
Check the assigned shift pattern for the employee
Review start times and overnight coverage.Review the previous day threshold configuration
Confirm the cutoff time used by the system.Compare affected clocking records
Identify whether the issue is consistent across specific shifts or employees.Validate reporting outcomes
Confirm whether payroll or attendance reports are aligning with expected working days.