Filter on Date and time
Posted on 2010-09-02
I have slightly tricky filter problem in Excel 2007.
I have a filter which filters on the previous days date. For example, if today is 02/09/2010, the filter would show the data for 01/09/2010. Unfortunately, the data imported have a time stamp included with the date.
I would like a filter which would filter from midnight at the start of the previous day until the end of the previous day.
If the following filter was applied:
ActiveSheet.Range("$A$1:$H$5000").AutoFilter Field:=1, Operator:=xlFilterValues, Criteria1:=Date - 1, Criteria2:=Time 00:00<=23:59
the data displayed would be:
Thanks in advance.