I am trying to do a very simple exploration where I search for stocks where today's close is >= the close on a specific date in the past.

The exploration I have is:
-----------
m:=11;
d:=31;
y:=2007;

colA
C >= ValueWhen(1,Month()=m AND DayOfMonth()=d AND Year()=y,C);

Filter
colA
------------
Every security comes up with the error, "Filter reference to N/A value in column A."

I have searched the forums and have found other exploations where there was a search on dates in the past, and the same coding using ValueWhen was used. I've double checked to make sure I'm inputting a date for which there is a price and there is. So, for the life of me I can't figure out what's wrong.

Troubled and confused...

Hey, thanks for the quick reply Hayseed.

As a test, I copied and pasted your exact exploration and still received the same result...N/A value in column A.

I even ran the exploration on the entire NYSE ticker list, knowing that at least ONE stock had to close lower than 7/2/2007!

Upon looking at the Exploration Notes, mine is equivalent to yours, except it says Records Required: 1. So, here is exactly what I have at the moment.

ColA

m:=7;
d:=2;
y:=2007;

a:= ValueWhen(1,Month()=m AND DayOfMonth()=d AND Year()=y,C);

C <= a

ColB through Col F are blank

Filter
colA

Options
Exploration Date: Use most recent date
Periodicity = Daily
Use Filter is checked

I've also verified that I've downloaded daily quotes, rather than weekly.

???

Hey there Hayseed...

It took me a while to figure out how to tell it to load a certain number of records because all of my other explorations were set to "Load Minimum Records." I guess I've been lucky so far that I haven't needed to change the setting. But, it works great now, and as usual, I appreciate your help!

Jon