Excel VBA Code Date Filter between two dates

[bhaskar_bkp]

I want to filter data between "15 apr 2010" and "26 apr 2010" . All Dates are stored in column B. The below code is generated by excel macro recorder but despite having dates between the specified range nothing is showing when I run the macro. Dates are stored in "dd/mm/yyyy" format
Please help me.
Thanx

ActiveSheet.Range("$B$5:$O$289").AutoFilter Field:=2, Criteria1:= _
">=15/04/2010", Operator:=xlAnd, Criteria2:="<=26/04/2010"

 

[Sahak]

Hi,

Change date format in code from dd/mm/yyyy to mm/dd/yyyy

ActiveSheet.Range("$B$5:$O$289").AutoFilter Field:=2, Criteria1:= _
        ">=4/15/2010", Operator:=xlAnd, Criteria2:="<=4/26/2010"

 

[bhaskar_bkp]

Thank u very much Sahak for ur help. I have searched for the solution for a long time & u solved it so easily.

I have another question. I gather the start date & end date using a popup calender. I use the following code.

Calendar.Show
startDate = Selection

Now "15/4/2010" is stored in "startDate" . How to change the date format of "startDate" from "dd/mm/yyyy" to "mm/dd/yyyy"?

Thanx in advance.

 

[bhaskar_bkp]

It worked. Thanx again Sahak for ur reply. Thanx to the Person Who Knows Excel All The Way.

I have solved the above question. I changed the code to .....

startDate = Format(startDate, "mm/dd/yyyy")

 

[Sahak]

You are very welcome.

 

[Timnewtonoz]

Hi there, is there any way to do the above:
. In Excel 2010?
. With a dialogue box to ask for start & end dates to search column B of the 'Data' sheet)
. And for found rows to be copied across to a sheet called 'Reports'?

 

[praveen tech]

hi there , i need a program to get data between the dates 7/5/2015 and 7/10/2015 in my excel document. can u help me with the code figure out a solution.

 

[martipe1]

hi there , i need a program to get data between the dates 7/5/2015 and 7/10/2015 in my excel document. can u help me with the code figure out a solution.

Probably late, but here it is


ActiveSheet.Range(YOUR RANGE).AutoFilter Field:=3, Criteria1:=">=7/05/2015", Operator:=xlAnd, Criteria2:="<=7/10/2015"