Table query based on date

Hey all

I have list of multiple promotions with a start date and end date
stored in a table thru a form. I then have a report that is generated to display all the entries

I would like to generate the report in such a way that if the end date of the promotion has already passed, it wont show up in the report ?


any help is greatly appreciated. Thanks !