Prev: R1C1 reference
Next: Converting excel 2007 to tab delimeter text file
From: BridgeBuilder on 26 Mar 2010 16:17
I'd like to return only data by filtering a date field for any date past the
current date. I can filter using [is greater than (>)] but it seems my only
choices are a date that is already in the field or a static date I enter. I
need to use an expression such as [CurrentDate] or [now()] but these don't
seem to work in Microsoft query as they do in Access or Crystal.

Microsoft Excel 2007
From: Don Guillett on 26 Mar 2010 16:58
Sub filterplustoday()
ActiveSheet.Range("A1").AutoFilter field:=1, _
Criteria1:=">" & Format(Date, "mm/dd/yyyy")
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"BridgeBuilder" <BridgeBuilder(a)discussions.microsoft.com> wrote in message
news:8AFD7947-F780-4241-BD10-61355EA2CE63(a)microsoft.com...
> I'd like to return only data by filtering a date field for any date past
> the
> current date. I can filter using [is greater than (>)] but it seems my
> only
> choices are a date that is already in the field or a static date I enter.
> I
> need to use an expression such as [CurrentDate] or [now()] but these don't
> seem to work in Microsoft query as they do in Access or Crystal.
>
> Microsoft Excel 2007

 | 
Pages: 1
Prev: R1C1 reference
Next: Converting excel 2007 to tab delimeter text file