I have a UDT with a date column called "Date of Event" where users can sign their names up to attend events
The table is sorted by "Date of Event"
I want to be able to filter out the events that occured before today so it only displays future events.
I can't figure out the filter statement to filter to show events that are supposed to occur today.
That is... if an event date was yesterday... I want the event to show up on the list.
If the event date is today or anytime in the future, I want the event to show up on the list
If the event was before yesterday, I want it to be filtered out of the list and not displayed.
[Date of Event]>#3/28/2009# would work, for example... to show events from the 29th an beyond if today is the 30th.
How do I make a filter statement that does this:
[Date of Event]>(Today-2)
Or, I'd be happy just knowing how to show events from Today and Beyond.
[Date of Event]>=Today , for example