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

• Required date is not consistent in user view and admin view when item assigned by admins.
• What is the logic to store Required Date timestamp in LMS Database？

SAP SuccessFactors Learning

Admin assignment:

• User entity-> Assigned Items tab
• Propagate assignment profile
• Synchronize assignment profile
• Learning Assignment Data Import
• Item entity-> Assign action
• Manage assignments

1. Required timestamp of admin assignment is 23:59:59, with date calculated based on assignment date in 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.

Note: About how assignment date is stored in database, please check KBA 3490433. 

Example1: 

Item has required period set to 7 days.

Admin's time zone is UTC+9 and assigned item at any timestamp on 2025-07-13 UTC+9. 

User's time zone is UTC-4.

Required date of admin 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.

Example2: 

Item has required period set to 7 days.

Admin's time zone is UTC-4 and assigned item at any timestamp on 2025-07-13 UTC-4.

User's time zone is UTC+9.

Required date of admin assignment will be 2025-07-20 23:59:59 UTC+9.

And it will be stored to database after converted to UTC, that is 2025-07-20 14:59:59 UTC.

• 3490433 - How is Assignment Date Stored in LMS Database 
• 3631200 - How is Required Date Stored in LMS Database when Manager Assigns Items 

learning, lms, required date, due date, inconsistent, mismatch, PH_STUD_CPNT, ASSGN_DTE, REQ_DTE, admin assignment, assignment date, different dates , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , How To