Customize filter for the date column

G

Guest

Hello,

I need some assistance in customizing my filter based on Date column. When I
set my criteria ( is greater than equal to ......10/01/2007), I don't seem to
get any lucky with my query result. I even try to format the whole Date
column to DATE, but I am still unable to get any result. The only way I can
get it going is by selecting the following condition: is equal
to.....10/02/2007 on and on.... This is very time consuming for a large
amount of data. Please advise.

Thanks,
 
R

Roger Govier

Hi

I suspect that some of the values in your column are not true Excel dates,
but text representations of the date.
With true Excel dates in the column, selecting Greater than or equal to
10/01/2007 works fine for me.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Custom filter Help! 1
Access Running Balance in Access 1
Advanced filter 7
Macro filter based on date criteria 4
Using Filter more than once 2
sumproduct with date range 4
Date / Time Filter 2
IF and AND formula for date field 6

Top