Macro Autofilter by today date?

[meetz]

How to use today formula in below coding to get all the records before today's date?

[COLOR=#333333]ActiveSheet.Range("$A$2:$M$377").AutoFilter Field:=7, Criteria1:=[/COLOR]"50"[COLOR=#333333]
[/COLOR][COLOR=#333333]        "<29.1.2011", Operator:=xlAnd[/COLOR]

 

[vschoet]

Hi,

This piece of code shows all dates before today.

ActiveSheet.Range([COLOR=#333333]("$A$2:$M$377").A[/COLOR]utoFilter Field:=7, Criteria1:= "<" & Format(Now(), "mm/dd/yyyy")

 

[meetz]

Thank you for the answer.

My question is if i want for today's date and every day i have to work on. So on daily bases i don't want to change date in coding.

Hi,

This piece of code shows all dates before today.

ActiveSheet.Range([COLOR=#333333]("$A$2:$M$377").A[/COLOR]utoFilter Field:=7, Criteria1:= "<" & Format(Now(), "mm/dd/yyyy")

 

[vschoet]

The "Now()" part returns the date of the day you run the code on. So tomorrow it will filter before tomorrow.
It seems that this is the way you want it to work?

 

[meetz]

Thanks alot bro..
It's working

The "Now()" part returns the date of the day you run the code on. So tomorrow it will filter before tomorrow.
It seems that this is the way you want it to work?

 

[Joe4]

The "Now()" part returns the date of the day you run the code on. So tomorrow it will filter before tomorrow.

Note that Now() actually returns date AND time (you are dropping the time part with the Format function).
If you want just the date portion, you could just use Date().

 

[meetz]

Ok Joe4

Thank you for the same.

Note that Now() actually returns date AND time (you are dropping the time part with the Format function).
If you want just the date portion, you could just use Date().