3631200 - How is Required Date Stored in LMS Database when Manager Assigns Items/Modifies Required Dates

• Required date is not consistent in user view and admin view when assigned by managers.
• What is the logic to store Required Date timestamp in LMS Database?
• After the manager modifies the Required/Due Date, the date selected by the manager is not the same as the date shown for the user.

SAP SuccessFactors Learning

1. Login to Learning as manager > My team view
2. Manage assignment > Add assignment to user/modify the due date
3. Required date is not consistent from user's view

The system processes due dates using the subordinate's time zone but displays them using the viewer's time zone. This creates discrepancies when managers and subordinates are in different time zones.

1. Required timestamp of manager assignment is 23:59:59, with date calculated based on assignment date in database, and user's time zone.
2. Then it will be converted to UTC and stored to database.
3. When user check the assignment from learning plan, this timestamp will be converted to user's current time zone and display the required date accordingly.

More information about how assignment date is stored in database, please check KBA 3490433. 

Note: Modifying a user's timezone after assignment will not modify the Required Date/Due Date until there is another calculation that needs to be done, such as a user completes the item and retraining is part of the curricula. The Required Date/Due Date are calculated upon assignment/modification and no re-calculation is done if a user's time zone preference is changed.

Assignment Example: 

• User's time zone is UTC-4.
• Item has required period set to 7 days.
• User has assignment date as 2025-07-13 00:00:00 stored in database.
• Required date of manager assignment will be 2025-07-20 23:59:59 UTC-4.
• And it will be stored to database after converted to UTC, that is 2025-07-21 03:59:59 UTC.

Due Date Modification Example:

• Manager timezone: UTC
• Subordinate timezone: EST
• Manager selects: September 9, 2025 as the new Due Date
• Save: Date saved as 2025-09-09 23:59:59 EST
• Database storage: Converted to 2025-09-10 04:59:59 UTC (+5 hours)
• Manager view: Displays 2025-09-10 (in UTC timezone)
• Subordinate view: Displays 2025-09-09 (converted back to EST)
• Result: Manager sees September 10th, subordinate sees September 9th (the originally intended date)

3490433 - How is Assignment Date Stored in LMS Database 

3632791 - How is Required Date Stored in LMS Database when Admin Assigns Items 

PH_STUD_CPNT, ASSGN_DTE, REQ_DTE, manager assignment, assignment date, different dates , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , How To