Using a Calculated End Date in the Modern SharePoint Calendar View Drop-Down
Hello All: I recently created an end date as a calculated field in Microsoft SharePoint List. The calcuation’s data type returned is the date and time format. I want to use this new end date as an actual end date in my SharePoint Calendar view. Unfortunately, the end date does not appear in the calendar view drop down because it is not considered a “Date and Time” type. How do I convert my newly calculated end date to the Type “date and time” so that it will appear in the Calendar view end date drop down menu? This calculation works in the classic sharepoint , but renders no value in the modern SharePoint. I did see a similar request from Waqas in February 6, 2024. The response from Sophia Papadopoulos does not work. Also, the Microsoft Moderator offered a response that was not helpful. See below:”We went through your post carefully and do understand your great idea of importing the calculated end date as an actual date into a calendar to arrange tasks efficiently. But we are really sorry to convey that it seems like we also failed to achieve it from our tests. Given this situation, I sincerely recommend you use Feedback Community to suggest this feature limitation and add your valuable idea in the SharePoint Feedback Community (microsoft.com) which is the best place to share ideas directly with the product building team and improve the Microsoft Products. ” Does anyone have a work-around to this issue? Please let me know. It is amazing how the end date calucation is able to be picked up by the calendar view in the Classic version and not the Moderate version. I look forward to your help. Thank you. BW Read More