I have a list of events and want to create a section ‘events happening this month’ and ‘upcoming events next month’
I store the start date of the event. I was trying to do a ‘group by’ and then set the constraint where the ‘event month’ is the same as ‘current month’ but I can’t figure out how to get it to work.
I’m not sure I understand…
Are you just asking how to constrain your RG to only show events who’s start date is within the current month?
Or is there more to your question?
So you just need to use the following two constraints on your RG search for events:
Event Start Date ≥ Current Date/Time: rounded down to Month
Event Start Date < Current Date/Time: rounded down to Month: +(Months) 1
This topic was automatically closed after 70 days. New replies are no longer allowed.