Excel date problem

[smiffo86]

Am using a command button and autofilter to only see things with todays date.

Sub TodaysFault()
    Sheets("Database").Select
    Selection.AutoFilter Field:=3, Criteria1:=Format(Now, "mm/dd/yyyy"), Operator:=xlAnd
End Sub

I've had a browse around the forums and found the

Criteria1:=Format(Now, "mm/dd/yyyy")

part. Got a feeling this is where I'm going wrong. Basically the Criteria1:= needs to be todays date and then once the macro has run autofilter only shows todays date of parts that I have in my sheet.