Get Calendar View of events from the past

[Livearus]

Hello, everyone,

how to set the "Start Time" for "Get calendar view of events" to the last 7 days. I would like to see all events of the past 2 weeks.

In addition, only events that have been canceled should be output.

I know about the query for the current events, but I can't get any further.

[Expiscornovus]

Hi @Livearus,

You can use expressions for the Startzeit und endzeit fields and use the adddays function to calculate a date in the past.

Use something like below and add them via the expression tab.

In my example I am looking back 14 days.

Startzeit

addDays(utcNow(), -14, 'yyyy-MM-ddTHH:mm:ss')

Endzeit

utcNow('yyyy-MM-ddTHH:mm:ss')

[Livearus]

Okay many thanks. It was somehow obvious. Can you also tell me what the correct filter query looks like for me? As I said, I would only like to have appointments issued that have been cancelled. So I think I need to filter by "Cancelled" in the subject? However, I only get error messages:

Example: subject eq 'Cancelled' or subject eq 'Cancel' - Subject does not exist
Example: subject contains 'Cancelled' - Subject does not exist
Example: contains(subject,'Cancelled')Is not allowed here

[Expiscornovus]

Hi @Livearus,

Did you cancel the appointments (as an organiser) or did somebody else cancel them?

In the first scenario the appointment would not be part of the view anymore and I think the events would not be part of the view of listed events.

[Livearus]

Scenario 2 applies. Someone else canceled the events. I'm not an organizer.