Hi Group,
It's me again....just got a quick question about a date search. I am
running a macro that I can enter a date in an input box, and then ask
it to search for every date on my log that fits a criteria pertaining
to that date.....
It will find every date that it is supposed to, i.e. < search date,
except ANY dates prior to Oct 1, 2007...(format is 10/1/2007).....I
have changed the dates to text to check to see if dates prior to that
have the correct numerical format, and they do. Now if I change the
macro to search date, the dates prior to Oct 1, 2007 show up along
with all the other dates that are actually search date. Has anyone
ran into this type of problem, and is there anyway to correct it?
Thanks to all!
Ken