Forum Discussion
Need help pulling dates from Calendar
We have a calendar that tracks all the meetings we have with clients. Our leadership is requests that we provide them an excel spreadsheet at the beginning of each month showing all the meetings that we had with our clients the previous month. This works well but because we have many recurring meetings, those are not showing up. I have a start time and end time for the meetings. So in order to extract the data I created a field for the month and year based off the start time. Here is my example:
- In May 2023, we created a recurring meeting every first Monday of each month.
- This is showing on our Calendars correctly, but when I pull the month and year from the start date, it is pulling May 2023 for every event. I need it to pull November 2024 for the November meeting and December 2024 for the December meeting and so on.
- How can I show the start and end time as the real time of the meeting?
1 Reply
hi cgotling , The problem in your case is that the recurring event is, in fact, just one list item, and what you see in the calendar is simply a representation of that single item. That is why the Year and Month values are calculated based on the initial item.
Of course, you can enter a single occurrence of a recurring event, but until you edit and save it, it will not be represented as a separate list item.
Please check this example: I created a recurring event called "test2" and for one day within this event, I made a change. This action created a new list item named "test2 exception."
Maybe you can ask users to edit all occurrences of the recurring event when it actually happens. This way, another list item will be created, which can then be exported to the report.
