Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter on date
I am trying to filter on a date.
Range("C8").AutoFilter Field:=3, Criteria1:="=10/08/2007 00:00", Operator :=xlAnd, Criteria2:="<=13/08/2007 24:00" ( I got that from recoding a macro) but that does not work from the code - some filtering is done but I get a blank table (when I was reording the macro I was getting the correct results). Any Idea? thanks Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter on date
I have found the reason (but still do not know how to solve it)
For some reason excel convert all my date to american format so 10/08/2007 become 008/10/2007 and therefor there is no result. All my setting are UK settings? Any idea "Dan" wrote: I am trying to filter on a date. Range("C8").AutoFilter Field:=3, Criteria1:="=10/08/2007 00:00", Operator :=xlAnd, Criteria2:="<=13/08/2007 24:00" ( I got that from recoding a macro) but that does not work from the code - some filtering is done but I get a blank table (when I was reording the macro I was getting the correct results). Any Idea? thanks Dan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter on date
Darn US dates <g
Dim date1_value As Date Dim date2_value As Date Sheets("Detail").Select date1_value = DateValue("10-Aug-2007") date2_value = DateValue("13-Aug-2007") Range("C8").AutoFilter Field:=1, _ Criteria1:="=" & Str(CDbl(date1_value)), _ Operator:=xlAnd, _ Criteria2:="<=" & Str(CDbl(date2_value)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dan" wrote in message ... I have found the reason (but still do not know how to solve it) For some reason excel convert all my date to american format so 10/08/2007 become 008/10/2007 and therefor there is no result. All my setting are UK settings? Any idea "Dan" wrote: I am trying to filter on a date. Range("C8").AutoFilter Field:=3, Criteria1:="=10/08/2007 00:00", Operator :=xlAnd, Criteria2:="<=13/08/2007 24:00" ( I got that from recoding a macro) but that does not work from the code - some filtering is done but I get a blank table (when I was reording the macro I was getting the correct results). Any Idea? thanks Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter latest date from multiple date entries | Excel Worksheet Functions | |||
Filter Date | Excel Discussion (Misc queries) | |||
Dupliate names with different date Filter for newest date | Excel Discussion (Misc queries) | |||
Date Filter?!? | Excel Programming | |||
Date filter using now() | Excel Programming |