Excel date problem

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

VB Code:

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

VB Code:

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.

Should I have done this in VBA?

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

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!

Anyone else got any idea?

Today's date is

VB Code:

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

Are you doing this in VB6 or Excel VBA?

Quote:

---

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"

Excel VBA, still having no luck :(

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

i.e. would this work instead :

VB Code:

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

Moved :)

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.

What ARE the cells formatted as ?

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.