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.

[smiffo86]

Should I have done this in VBA?

[smiffo86]

Just messing around with it would it have anything to do with the date format?

[smiffo86]

Just need to know the code for todays date, tried google and going through the old forum posts and have nothing. Any help will be appreciated!

[smiffo86]

Anyone else got any idea?

[Hack]

Today's date is

Format(Now, "mm/dd/yyyy")

Are you doing this in VB6 or Excel VBA?

[Radjesh Klauke]

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

Seems you already had your answer in your question. Seems this is Excel -VBA 'cause of the "Sheets("Database").Select"

[smiffo86]

Excel VBA, still having no luck

[TheBionicOrange]

Have you got your days and months the correct way around for your data ?

i.e. would this work instead :

Format(Now, "dd/mm/yyyy")

[RobDog888]

Moved

[smiffo86]

Would it have anything to do with the format of the cell or anything like that? The date is in the correct format as far as I can see, dd/mm/yyyy and this is how I have it in the code.

[TheBionicOrange]

What ARE the cells formatted as ?

[Ecniv]

I think you either

a) need to turn the filter off then back on again
or
b) refresh/requery the autofilter

Either way you'd need to do call that as the workbook/sheet opens.