3490433 - How is Assignment Date Stored in LMS Database

• Assignment date is not consistent when assigned by admins via different methods, consequently Required date based on assignment is also not consistent.
• Assigned date in user view is not correct, when user self-assigns an item, it immediately shows as the day before.
• How is the logic to store Assignment Date timestamp in LMS Database？

SAP SuccessFactors Learning

1. Admin's time zone is set to Europe/Berlin.
2. The admin opens a particular item details page from Learning activities -> Items -> search for an item -> Item Details. 
3. The admin assigns the item to a user from Actions - Assign. Note the assign date. 
4. After successful assignment, go to People -> Users -> search for the user  -> Assigned Items. The assigned Date displayed here is one day earlier than the date in the step 3

• Admin assignment:
  Currently this is not consistent cross the application when assigned via different methods.
  As per LMS Engineering, there are some patterns observed:

• • From item entity page, leave default assign date (current date in admin time zone), e.g. 2024-07-02 15:08:19
     >>Assignment date is stored as last update time, taken from admin time zone and converted to UTC.
  • From user entity page (assigned items tab), click (+) icon and assign item
     >> Assignment date is stored as current date 00:00, with date taken from admin time zone, e.g. 2024-07-02 00:00:00  (NO conversion to UTC).

• User assignment:
  Similarly, user assignment is stored as 00:00 of their time zone in any given day, and not converted to UTC.
  So when user time zone is behind UTC, for example UTC-6, in user view the date appears to be one day earlier.
  E.g. User time zone is UTC-6 and self-assigns a course on 2024-07-02 17:00:00 (UTC-6), this will be stored as 2024-07-02 00:00:00 UTC.
  This is converted to user preferred time zone and becomes 2024-07-01 (UTC-6) in user view.

• Admin assignment:
  LMS Engineering team has reviewed the different assignment methods and will improve consistency for admin assignments in 2505 release.
  Post release, assignment date will be consistent across LMS for admin assignments from different impact areas such as :

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

The assignment date picked by admin (or if not picked, by default current date in admin's time zone) will be stored as 00:00:00, with date taken from admin's current time zone, and converted to UTC.

For example: 
If the admin is in EST(UTC-4) and assign date picked as 2024-07-02, then it is displayed to admin as 2024-07-02 irrespective of the impact area it is assigned from. 
In database it is stored as 2024-07-02 4:00:00 AM as date is considered as 2024-07-02 00:00:00 in EST.
Same applies for other time zones.

• User assignment:
  However, user self-assignment is considered expected behaviour as it is stored consistently as 00:00 of any given day in user time zone.
  The discrepancy in user view depends on whether user time zone is ahead or behind UTC (Users with time zone ahead of UTC will not see assigned date becomes one day earlier).
  If you wish to change this behaviour, we recommend you create an enhancement request in SAP Customer Influence so LMS product team might consider it for future improvement.

For Example:

If an admin is in Japan and assigns to a user in Ireland, it will be the day prior on the users side.

However, on the admin side , admin should see it on the date that was given when the Item was assigned, the assignment date picked by admin. [This will be the way it should work post 2505 release as mentioned above]

2930781 What does Information on dates in the Assigned Item section of the user in new Admin UI mean?

2389381 Learning Item Required by Date is showing one day later in Supervisor/Manager page view

Assignment date, admin assignment, user assignment, required date, PH_STUD_CPNT, ASSGN_DTE, REQ_DTE, different date, LRN-192823 , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , How To