How to get the first event after today and tomorrow in KWGT? (Exclude events from today and tomorrow)

General
,
1

Hi everyone,

I’m trying to create a formula in KWGT to display the first upcoming event excluding events from today and tomorrow.

The issue is that, for example, if I have events scheduled for today and tomorrow, I want the widget to show the first event that is from the day after tomorrow onwards.

I’ve tried using the function $ci(title, 1)$ to get the second event, but it doesn’t always work because events can be very close (like today and tomorrow), and I want to exclude those.

I also tried formulas using sd >= d(2) or (a0d), but I get errors or it doesn’t work properly because I’m not sure how to correctly filter events based on the date.

Could someone who is experienced with KWGT calendar functions help me with a formula that returns the title of the first event that is not today or tomorrow, regardless of how many days are between events?

Thanks in advance!

2

Hi there,

Try either one of these code snippet.

For the first event, on the day after tomorrow

$ci(title,0,a2d)$

For the first timed event, on the day after tomorrow

$ci(title,e0,a2d)$

For the first all day event, on the day after tomorrow

$ci(title,a0,a2d)$

I hope this would help.

Did you find the most helpful response to your issue?
Please kindly press the :check_box_with_check: Solution button to mark it as the solution.
This would help others with the similar issue.
:smiling_face::+1:

2 Likes