DateTime issue in SharePoint

%3CLINGO-SUB%20id%3D%22lingo-sub-767333%22%20slang%3D%22en-US%22%3EDateTime%20issue%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767333%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20query%20about%20the%20datetime%20shown%20in%20SharePoint%20-%20has%20anyone%20else%20noticed%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20using%20a%20date%20picker%20(DateOnly%20Display%20Format%20but%20DateTime%20FieldTypeKind)%20in%20a%20listitem%20in%20SharePoint%202016%2C%20the%20value%20of%20the%20datetime%20when%20querying%20the%20listitem%20with%20PowerShell%20shows%20the%20datetime%20value%20as%20an%20hour%20before%20the%20selected%20date%20in%20SharePoint%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20when%2005-06-2019%20is%20selected%20in%20the%20date%20picker%20in%20a%20web%20browser%20the%20date%20returned%20in%20PowerShell%20shows%2004-06-2019%2023%3A00%20rather%20than%2005-06-2019%2000%3A00.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20raised%20a%20support%20call%20with%20Microsoft%20however%20progress%20is%20very%20slow%20so%20just%20wondered%20if%20anyone%20else%20has%20noticed%20the%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20is%20interested%20a%20script%20can%20be%20provided%20to%20reproduce%20the%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-768415%22%20slang%3D%22en-US%22%3ERe%3A%20DateTime%20issue%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380024%22%20target%3D%22_blank%22%3E%40hjones_19%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsually%20date%20and%20time%20issues%20like%20you%20mentioned%20happens%20if%20regional%20settings%20of%20site%20is%20not%20as%20expected.%20Please%20review%20regional%20setting%20of%20the%20site%20and%20set%20it%20based%20on%20your%20region%20and%20see%20if%20you%20still%20see%20the%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-769612%22%20slang%3D%22en-US%22%3ERe%3A%20DateTime%20issue%20in%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769612%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F18230%22%20target%3D%22_blank%22%3E%40Rahul%20Suryawanshi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Rahul%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response.%20The%20regional%20settings%20of%20the%20site%20are%20as%20expected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20screenshot%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20746px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124175i21D14A06FF7D9AF2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22MSIssue.jpg%22%20title%3D%22MSIssue.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello All,

 

I have a query about the datetime shown in SharePoint - has anyone else noticed this?

 

When using a date picker (DateOnly Display Format but DateTime FieldTypeKind) in a listitem in SharePoint 2016, the value of the datetime when querying the listitem with PowerShell shows the datetime value as an hour before the selected date in SharePoint 2016.

 

For example, when 05-06-2019 is selected in the date picker in a web browser the date returned in PowerShell shows 04-06-2019 23:00 rather than 05-06-2019 00:00.

 

We have raised a support call with Microsoft however progress is very slow so just wondered if anyone else has noticed the issue?

 

If anyone is interested a script can be provided to reproduce the issue.

2 Replies
Highlighted

@hjones_19 

Usually date and time issues like you mentioned happens if regional settings of site is not as expected. Please review regional setting of the site and set it based on your region and see if you still see the issue.

 

 

Highlighted

@Rahul Suryawanshi 

Hi Rahul,

 

Thank you for your response. The regional settings of the site are as expected.

 

Please refer to the screenshot below:

MSIssue.jpg