Autofilter with date field

Hi,

In Autofilter, how to handle between the date format in cells and input date format(for criteria)?
For example, date format in cells is d/m/yy but the input date format is dd-mmm-yyyy.

Thx

Hi Gabch,

Try something like:

Range("A1").AutoFilter Field:=1, _
Criteria1:=">" & CLng(Range("E1").Value)

or

Range("A1").AutoFilter Field:=1, _
Criteria1:=">" & CLng(DateValue("01/12/1944"))



---
Regards,
Norman



"gabch" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> In Autofilter, how to handle between the date format in cells and input
> date format(for criteria)?
> For example, date format in cells is d/m/yy but the input date format
> is dd-mmm-yyyy.
>
> Thx
>
>
> --
> gabch
> ------------------------------------------------------------------------
> gabch's Profile:
> http://www.excelforum.com/member.php...o&userid=30662
> View this thread: http://www.excelforum.com/showthread...hreadid=512183
>