Using Inputboxes to apply date filter TOO SIMPLE FOR U BOFS?

[idioteque]

Hi,

I am using this in my macro as well as input boxes to decipher what DBegin and DEnd values are.

I am just running this as an example and instead of filtering the dates, it filters all dates in that column and don't understand why as the code looks as if it should work fine;

Dim dbegin As Variant, dend As Variant
dbegin = "01/11/2003"
dend = "30/11/2003"


Selection.AutoFilter Field:=12, Criteria1:=">=" & dbegin, Operator:= _
xlAnd, Criteria2:="<=" & dend

Please please, if anyone can help it would be gratefully appreciated.

Regards

Will

 

[Andrew Poulsom]

Re: Using Inputboxes to apply date filter

VBA has problems with European style dates. This worked for me:

Sub Test()
    Dim dbegin As Date, dend As Date
    dbegin = DateValue("01/11/2003")
    dend = DateValue("30/11/2003")
    Selection.AutoFilter Field:=12, Criteria1:=">=" & CLng(dbegin), Operator:= _
    xlAnd, Criteria2:="<=" & CLng(dend)
End Sub

 

[idioteque]

Re: Using Inputboxes to apply date filter TOO SIMPLE FOR U B

Perfect!

Thanks for that Andrew - just what I was looking for.

Will