Fix SharePoint Calendar Showing Creation Date Instead of Event Date
Question details
The user needs to correct a SharePoint calendar that incorrectly maps and displays scheduled events on the day they were created rather than the intended event date.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Adding and viewing meeting events within a SharePoint calendar view.
- Observed behavior
- Events appear on the calendar based on their creation date instead of the intended meeting date, and manually selecting a date to add an event does not change this behavior.
Ensure you have at least 'Edit' or 'Design' permission levels in your SharePoint site to modify list and calendar view settings.
Modify the Calendar View Settings to Use Event Dates
Update the calendar view configuration to pull from the 'Start Time' and 'End Time' columns instead of the 'Created' column.
SharePoint calendars rely on specific list columns to determine where an event should be placed on the grid. If the view is accidentally configured to read the 'Created' system column, all events will plot on the day the user typed them in, regardless of the actual meeting schedule.
Log in to your SharePoint site and open the calendar list that is experiencing the date display issue.
Click on the 'Calendar' tab located in the top ribbon to reveal management options, then click on 'Modify View' (or 'Edit Current View' in modern SharePoint sites).
Scroll down the settings page until you find the 'Time Interval' section. This section dictates which data columns the calendar grid uses for plotting.
Check the dropdown menus for 'Begin' and 'End'. Change the 'Begin' field to 'Start Time' (or your specific custom event date field) and change the 'End' field to 'End Time'.
Scroll to the bottom or top of the page and click 'OK'. Your calendar will refresh and immediately place all existing events onto their correct meeting dates.
Enhance Your Productivity with WPS Office
While you manage team schedules and lists in SharePoint, streamline your local document, spreadsheet, and presentation creation with WPS Office. It provides a lightweight, highly compatible alternative to Microsoft Office without the hefty subscription fees.
- 1. Download and Install: Visit the official WPS Office website to download the free suite for your operating system.
- 2. Open WPS Spreadsheet: Launch the application and select 'Spreadsheet' from the main dashboard.
- 3. Access Calendar Templates: Click on 'New' and use the search bar to find 'Calendar' or 'Schedule' templates to quickly organize team events outside of SharePoint.
Frequently Asked Questions
Why did my SharePoint calendar default to the 'Created' date?
This typically occurs if the calendar view was modified by another user, or if the calendar was generated from a standard custom list where the default 'Start Time' and 'End Time' columns were not properly mapped to the view's Time Interval settings.
Will fixing the calendar view alter my existing event times?
No. Changing the calendar view settings only dictates which columns are used to draw the calendar interface. Your previously entered event start and end times remain safely stored in the list database.
How do I create a custom date field for my SharePoint calendar?
Navigate to Calendar Settings > Create Column. Choose 'Date and Time' as the column type, assign it a name, and save. You can then map this new column in the 'Time Interval' section under 'Modify View' to use it as the primary event date.
Can I show both the creation date and the event date on the calendar view?
In the standard graphical monthly calendar view, only one date range (Begin and End) can dictate where the event block sits. However, you can add the 'Created' field to the event's tooltip, display it in the detail pop-up, or view it by switching to an 'All Events' standard list view.
