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.

Advanced Filter using a range name as the criteria
 

Hi,

If you are doing this in a macro, show us your code.

If not, your criteria are must look something like this

Event Date Event Date
=1/3/2008 <=1/5/2008

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Joe" wrote in message
...
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.