Date Query

[DBaxter]

I am trying to select data in my expiration field that is
less than or equal to Dec. 31, 2003. I typed <="12/31/03"
in the criteria and I still get dates in 2004! What do I
need to know?

 

[Van T. Dinh]

Nope. You are comparing Text with your expression, NOT date.

Try <=#12/31/2003#

 

[DBaxter]

Nope, that came up with nothing. The problem is the
database field is a text field, not a true date field.
There are things like 11P=1/2/03;

 

[Van T. Dinh]

OK ... if it is a Text Field, you definitely compare Text and therefore you
get results different from what you expected. Surely you can't expect
Access to work miracles.

There may be work-arounds but I can't see the translation from 11P to 1/2/02
(Jan 2 or 1 Feb?). Post some examples of the values in the (date) Text
Field and their translation to dates.