filtering dates
 

I was looking for a way to filter dates in a database to extract a range of
data between one date and another date. What's the best way to do this? I
seem to be having problems with my advanced filter.

You coud use Custom on AutoFilter, use 'is less than or equal to' the end
date, use the operator 'And', then 'is greater than or equal to' the start
date.
Regards,
Alan.
"mindy" wrote in message
...
I was looking for a way to filter dates in a database to extract a range of
data between one date and another date. What's the best way to do this? I
seem to be having problems with my advanced filter.

Hi mindy

EasyFilter can do this for you if you want
http://www.rondebruin.nl/easyfilter.htm

Another way is to Use AutoFilter (use Custom : greater than and less than)

Then Copy the filter result

1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5SpecialCurrent regionOK
3) Press Alt ; to select all visible data or use F5SpecialVisible cells onlyOK
4) Ctrl c or EditCopy
5) InsertWorksheet
6) Ctrl v or EditPaste



--
Regards Ron de Bruin
http://www.rondebruin.nl


"mindy" wrote in message ...
I was looking for a way to filter dates in a database to extract a range of
data between one date and another date. What's the best way to do this? I
seem to be having problems with my advanced filter.

one way
DataAuto FilterCustomselection 1 greater than or equal toandless than
or equal to.
HTH


"mindy" wrote:

I was looking for a way to filter dates in a database to extract a range of
data between one date and another date. What's the best way to do this? I
seem to be having problems with my advanced filter.