Date Query

  • Thread starter Thread starter DBaxter
  • Start date Start date
D

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?
 
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;
 
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.
 
Back
Top