Good afternoon!

I recorded a macro to filter a database to show records where the entry in
column 1 was between two dates thus:

Sub DateFilterOn()
Range("MainDatabaseStart").AutoFilter Field:=1, _
Criteria1:=">=23/10/2007", Operator:=xlAnd, _
Criteria2:="<=22/11/2007"
End Sub

When I run the code, it filters the database down and displays no rows at
all (which is incorrect, as there are loads of them that meet the criteria).
If I then go into Data Filter Custom manually on the first DB column, the
criteria from the code appear in the dialog box and when I click "OK", the
database is correctly filtered.

Can anyone tell me where I'm going wrong, please? Why won't my code filter
my data correctly without the manual intervention?

Thanks in advance.

pete

Hi Pete

Use the US date format mm/dd/yyyy instead of the DMY you use now in the code



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Pete Rooney" <(E-Mail Removed)> wrote in message news:543A02AA-54B0-47FA-9A06-(E-Mail Removed)...
> Good afternoon!
>
> I recorded a macro to filter a database to show records where the entry in
> column 1 was between two dates thus:
>
> Sub DateFilterOn()
> Range("MainDatabaseStart").AutoFilter Field:=1, _
> Criteria1:=">=23/10/2007", Operator:=xlAnd, _
> Criteria2:="<=22/11/2007"
> End Sub
>
> When I run the code, it filters the database down and displays no rows at
> all (which is incorrect, as there are loads of them that meet the criteria).
> If I then go into Data Filter Custom manually on the first DB column, the
> criteria from the code appear in the dialog box and when I click "OK", the
> database is correctly filtered.
>
> Can anyone tell me where I'm going wrong, please? Why won't my code filter
> my data correctly without the manual intervention?
>
> Thanks in advance.
>
> pete

Ron,

Nice to hear from you again!

As usual, spot on answer :-)

Thank you!

Pete

"Ron de Bruin" wrote:

> Hi Pete
>
> Use the US date format mm/dd/yyyy instead of the DMY you use now in the code
>
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Pete Rooney" <(E-Mail Removed)> wrote in message news:543A02AA-54B0-47FA-9A06-(E-Mail Removed)...
> > Good afternoon!
> >
> > I recorded a macro to filter a database to show records where the entry in
> > column 1 was between two dates thus:
> >
> > Sub DateFilterOn()
> > Range("MainDatabaseStart").AutoFilter Field:=1, _
> > Criteria1:=">=23/10/2007", Operator:=xlAnd, _
> > Criteria2:="<=22/11/2007"
> > End Sub
> >
> > When I run the code, it filters the database down and displays no rows at
> > all (which is incorrect, as there are loads of them that meet the criteria).
> > If I then go into Data Filter Custom manually on the first DB column, the
> > criteria from the code appear in the dialog box and when I click "OK", the
> > database is correctly filtered.
> >
> > Can anyone tell me where I'm going wrong, please? Why won't my code filter
> > my data correctly without the manual intervention?
> >
> > Thanks in advance.
> >
> > pete
>