Thread: 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 !

Hi manny_cb,

Assuming you have built a nice query from the table to feed the report, then all you need to do is add this:

Code:

	
>=Date()

as criteria for the end date field in the query.

Cheers,