Others

How to Fix Microsoft Forms Selecting the Wrong Date in Calendar Questions

Chanuka Geekiyanage Oct 12, 2026 869 views

Question details

The user needs to fix an issue in Microsoft Forms where a calendar question records the date the form was submitted rather than the future date selected by the respondent.

Fix Microsoft Forms Selecting the Wrong Date in Calendar Questions

Product: Microsoft Forms
Device & OS: not provided
Scenario: Collecting responses via Microsoft Forms where respondents need to select a specific future date using a calendar question.
Observed behavior: The submitted response ignores the respondent's selected future date and instead records the date on which the form was completed.

Before you start

Ensure that your Microsoft Forms survey is actively saving responses and that you have administrator or editor access to review the form settings.

Solution 1Recommended

Verify Date Field and Test Across Browsers

Check the form configuration and rule out browser-specific or network-specific caching issues.

Sometimes, browser cache or network synchronization delays can cause form submissions to default to the current timestamp instead of capturing the selected input.

Verify the question type

Open your form in Microsoft Forms and ensure the question is strictly set as a 'Date' field, not a standard text field.

Test in a different browser

Copy the form's sharing link and open it in a different web browser (e.g., Edge, Chrome, Firefox) or in an Incognito/InPrivate window.

Test on a different network

Connect your device to a different network, such as a mobile hotspot, and submit a test response with a future date to see if the issue persists.

Verify Date Field and Test Across Browsers

Solution 2

Contact Your Microsoft 365 Administrator for Backend Support

If the issue is caused by a tenant service or backend synchronization error, Microsoft Support must intervene.

Free Microsoft Office alternative

Analyze Form Data With WPS Office

While Microsoft Forms manages the survey collection, analyzing the exported data requires a reliable spreadsheet application. WPS Office is a free, lightweight alternative to Microsoft Office that offers seamless format compatibility, a familiar UI, and easy migration for all your document needs.

1. Download WPS Office: Visit the official WPS website to download and install the free office suite.
2. Export Form Data: In Microsoft Forms, click 'Open in Excel' to download your collected responses.
3. Analyze with WPS Spreadsheet: Open the downloaded .xlsx file in WPS Spreadsheet to view, filter, and correct any date entries.

100% compatible with Microsoft Excel (.xlsx) formats for analyzing exported form responses.Free and lightweight suite for Word, Excel, and PowerPoint alternatives.Familiar user interface ensuring a seamless migration from Microsoft Office.Cross-platform support for Windows, Mac, Linux, iOS, and Android.

Frequently Asked Questions

Why is Microsoft Forms changing my selected date to today's date?

This usually happens due to a backend synchronization glitch in Microsoft 365, or browser caching issues that override the selected input with the current submission timestamp during data upload.

Can I fix the wrong dates in my exported Excel file?

Yes, once you export the responses to an Excel workbook, you can manually correct the dates using a spreadsheet program like WPS Spreadsheet or Microsoft Excel.

Who is my Microsoft 365 Administrator?

Your administrator is typically the person who set up your organization's Microsoft 365 account, often someone in your IT department or a technical support provider for your school or company.

Office Quick Solutions