extremely strange behavior of date/time columns in modern experience

%3CLINGO-SUB%20id%3D%22lingo-sub-2986495%22%20slang%3D%22en-US%22%3Eextremely%20strange%20behavior%20of%20date%2Ftime%20columns%20in%20modern%20experience%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2986495%22%20slang%3D%22en-US%22%3E%3CP%3EA%20user%20brought%20this%20issue%20to%20my%20attention%20and%20at%20first%20I%20assumed%20it%20was%20some%20kind%20of%20user%20error.%20However%2C%20after%20extensive%20testing%20across%20different%20sites%20with%20different%20lists%2C%20it's%20clear%20that%20there%20is%20some%20kind%20of%20bug%20with%20the%20new%20%22modern%22%20date%2Ftime%20control%20in%20SharePoint%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20happening%20is%20that%20when%20the%20time%20portion%20of%20a%20date%2Ftime%20column%20is%20set%20to%20PM%20(e.g.%3A%201%3A00%20PM)%20AND%20either%20the%20month%20OR%20the%20day%20is%20a%20single%20digit%20value%20(e.g.%3A%2001%20for%20January%20or%2001%20for%20the%20first%20of%20the%20month)%2C%20putting%20the%20field%20into%20edit%20mode%20will%20result%20in%20the%20PM%20being%20changed%20to%20AM.%20For%20example%2C%2001%2F01%2F2022%2012%3A00%20PM%20with%20change%20to%2001%2F01%2F2022%2012%3A00%20AM.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20both%20the%20month%20and%20day%20are%20two%20digit%20numbers%20(e.g.%3A%2010%2F10%2F2021)%2C%20the%20issue%20does%20not%20occur.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20occurs%20in%20Microsoft%20Edge%2C%20Google%20Chrome%20and%20Mozilla%20Firefox%20(all%20latest%20builds%20as%20of%2011%2F19%2F2021)%20running%20on%20Windows%2010%20as%20well%20as%20the%20Microsoft%20Lists%20PWA%20(which%2C%20in%20reality%2C%20is%20using%20Edge%20under%20the%20hood).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20%3CEM%3E%3CSTRONG%3Edoes%20not%20occur%3C%2FSTRONG%3E%3C%2FEM%3E%20in%20any%20browser%20on%20Mac%20OS%2C%20so%20it's%20possible%20this%20is%20related%20to%20list%20sync%20(Project%20Nucleus).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUPDATE%3A%20I%20believe%20this%20is%20directly%20related%20to%20Project%20Nucleus.%20I%20went%20into%20the%20settings%20for%20a%20few%20of%20the%20lists%20that%20were%20displaying%20this%20issue%20and%20disabled%20syncing%20(Advanced%20settings%20%26gt%3B%20Set%20%22Offline%20Client%20Availability%22%20to%20%22No%22)%20and%20the%20issue%20promptly%20disappeared.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20short%20video%20of%20the%20issue%20as%20its%20occurring%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.screencast.com%2Ft%2FELi3QPRMeIGD%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.screencast.com%2Ft%2FELi3QPRMeIGD%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2986495%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Contributor

A user brought this issue to my attention and at first I assumed it was some kind of user error. However, after extensive testing across different sites with different lists, it's clear that there is some kind of bug with the new "modern" date/time control in SharePoint Online.

 

What is happening is that when the time portion of a date/time column is set to PM (e.g.: 1:00 PM) AND either the month OR the day is a single digit value (e.g.: 01 for January or 01 for the first of the month), putting the field into edit mode will result in the PM being changed to AM. For example, 01/01/2022 12:00 PM with change to 01/01/2022 12:00 AM. 

 

If both the month and day are two digit numbers (e.g.: 10/10/2021), the issue does not occur.

 

This occurs in Microsoft Edge, Google Chrome and Mozilla Firefox (all latest builds as of 11/19/2021) running on Windows 10 as well as the Microsoft Lists PWA (which, in reality, is using Edge under the hood). 

 

It does not occur in any browser on Mac OS, so it's possible this is related to list sync (Project Nucleus). 

 

UPDATE: I believe this is directly related to Project Nucleus. I went into the settings for a few of the lists that were displaying this issue and disabled syncing (Advanced settings > Set "Offline Client Availability" to "No") and the issue promptly disappeared.

 

Here is a short video of the issue as its occurring: https://www.screencast.com/t/ELi3QPRMeIGD

 

0 Replies