Others

How to Fix SharePoint Date Picker Showing Only Month and Year

Maira Mehtab Sep 27, 2026 868 views

Question details

The user is experiencing an issue where a custom SharePoint Online date picker intermittently displays only the month and year (MM/YYYY) instead of the complete date.

Product: SharePoint Online
Device & OS: not provided
Scenario: Using a custom date picker in SharePoint Online, particularly on the first business day of the month.
Observed behavior: The date picker fails to display the day, showing only the MM/YYYY format instead of the standard complete date format.

Before you start

Verify whether the issue occurs across multiple different web browsers and check your browser's developer console for any script errors before modifying the code.

Solution 1Recommended

Diagnose Browser and Custom Code Errors

Use this approach to isolate whether the issue is caused by a specific browser limitation or a failure in the custom code implementation.

Since SharePoint's default date picker generally uses a full day/month/year format, the intermittent MM/YYYY display is heavily tied to custom code logic. Diagnosing the exact failure point on the client side is crucial.

Test across multiple browsers

Open the SharePoint site in different browsers such as Microsoft Edge, Google Chrome, and Mozilla Firefox to confirm if the MM/YYYY behavior is browser-specific.

Check for JavaScript errors

Press the F12 key on your keyboard to open the browser's Developer Tools. Navigate to the 'Console' tab and look for any red JavaScript error messages when the date picker is activated.

Review first-of-month logic

Review the deployed custom code specifically for date-parsing logic that handles the first business day of the month, as edge cases in date calculation often cause display truncation.

Solution 2

Consult the Microsoft Q&A Community

Seek assistance from SharePoint developers when custom code behaves unexpectedly after working properly for years.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Management

While troubleshooting custom SharePoint development issues, you can rely on WPS Office for a lightweight, highly compatible alternative for your daily document, spreadsheet, and presentation tasks. It offers a familiar interface and comprehensive features without the heavy overhead.

1. Visit the official website: Go to the official wps.com website to download the latest version of WPS Office.
2. Run the installer: Open the downloaded executable file and click 'Install' to set up the software on your device.
3. Open your documents: Launch WPS Office and seamlessly open your existing Microsoft Office files without formatting loss.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats.Lightweight installation with rapid startup times.Familiar user interface requires no steep learning curve.Cross-platform support for Windows, Mac, Linux, iOS, and Android.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the SharePoint date picker show only MM/YYYY?

This issue typically occurs when custom code has been applied to the date picker. Intermittent failures, such as on the first business day of the month, indicate a bug in the custom date-parsing logic rather than a default SharePoint error.

How do I know if my date picker is custom or default?

SharePoint's default date picker always uses a complete date format (like DD/MM/YYYY or MM/DD/YYYY). If the picker restricts you to MM/YYYY, it confirms that a custom implementation is controlling the format.

Where can I get help for custom SharePoint development issues?

The best resource for troubleshooting custom code is the Microsoft Q&A Community. Posting your issue under the 'SharePoint Development' tag connects you directly with specialized developers and Microsoft engineers.

Office Quick Solutions