K
Ken
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
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