Advanced Filter using a range name as the criteria
I am running a macro and want to select records from a database that are
within a date range that the macro prompts for.
So macro gets STARTDATE and ENDDATE and has stored them in a date formatted
field.
STARTDATE=1/3/2008 and ENDATE=1/5/2008
The database is
Event Date Event Name
1/1/2008 Event 1
1/3/2008 Event 2
1/5/2008 Event 3
1/7/2008 Event 4
What is the criteria to use? I have tried "everything" but must have done
something wrong.
|