Hans Rein wrote:
I want to make a portal with current and upcoming events. The construction I've made so far is:
Hi Hans, since you want current and upcoming events (inclusive), I would handle it this way:
Create a calculation (date ) called cToday as: Get ( CurrentDate ) ... and make it unstored in Options
Create a global (date) called gUntil.
Your relationship would then be:
Main:: cToday <= PortalTable:: EventDate
Main:: gUntil >= PortalTable:: EventDate
UPDATE: Place gUntil above your portal so Users can extend out the end date as they wish (maybe even attach a drop-down calendar for them)
Thanks for the reaction. Maybe I wasn't complete enough.
The EventDate can take one or more days because it has a start and end date.
I hope it clears it up a little.
Then the relationship should be:
Main:: cToday <= PortalTable:: EventStartDate
Main:: gUntil >= PortalTable:: EventEndDate