custom filter dates

  • Thread starter Thread starter alistair01
  • Start date Start date
A

alistair01

Hi, I am trying to use the autofilter function to filter out records i
a list that are more than 30 days old. The column I am trying to filte
takes the format dd/mm/yyyy hh:mm. Any ideas
 
Add another column to test the date column for greater than 30 days old,
with a Y/N result, and filter on that.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
alistair01 > said:
Hi, I am trying to use the autofilter function to filter out records in
a list that are more than 30 days old. The column I am trying to filter
takes the format dd/mm/yyyy hh:mm. Any ideas?
Click to expand...

The best you can do with the list as it is would be this:
Click the autofilter arrow for the date column and choose Custom.
Where the dialog box says "Show rows where [the date]". choose "is greater
than".
In the box to the right of this, choose a date 30 days before today (8 Dec
2003).
OK.

To improve on this, you would need to add a column that determines whether
or not the date meets your criterion, using for example:
=(TODAY()-A1)>30
Then you would just autofilter on this being FALSE.
 
Back
Top