Have a ‘base’ that I can program to show me upcoming events, within a range I specify that includes both recurring and non-recurring event types. I’d like to have notes for recurring events like birthdays and anniversaries, and non-recurring events like an upcoming family reunion. Ideally, I’d be able to have the ‘base’ always be looking ahead 30 days(or other number of days that I specify)…and it would show, cumulatively, a list of event notes, non-recurring where the date property value is within the upcoming 30 days from current datetime, together with recurring event notes where the month/day(properties on the note?) are within the next 30 days.
Things I have tried
Creating a custom property called ‘EventMonthRecurring’, and custom property called ‘EventDayRecurring’, just playing around setting the values to ‘April’, and ‘04’ respectively.
Perhaps ‘EventMonthRecurring’ should be numeric month value? but still, I’m seeking to understand whether a base’s filter can use a query that uses these values and compares against something like, is equal to or greater than current datetime, AND is less than current datetime+30(adjustable window value). Is there already other functionality that exists that accomplishes this and I’m just completely going in the wrong direction? any ideas or suggestions would be greatly appreciated.
just to clarify…. the concept isn’t to be able to view ‘this week’, or ‘this month’, or ‘next month’, or ‘this year’, but rather have it dynamically be a rolling window of number of upcoming (configurable) days. …so, if set to 40 days, would dynamically today show all events including today and all days through 4/30.
That results in a column on the base shown as “DaysUntilNextOccurrence”, but no values are being populated.
My plan is, if I can get this function to work, then I should be able to just put a filter on top of it for the number of days(forward) I want it to show events for.