What's wrong with my DateValue Query

  • Thread starter Thread starter mann
  • Start date Start date
M

mann

"SELECT DateBooked FROM DateCatalog WHERE (NOT(ISNULL
(DateBooked)) AND DateValue(DateBooked) >=1/1/2001)"

First, I am converting the DateBooked field using
DateValue function bcoz it is a Text Datatype.(I used
Text Datatype in my DateBooked field bcoz I found it hard
to Insert a NULL value if it's in Date DataType).

What's wrong with my Query, it doesn't return any single
record.

P.S.
If you could teach me how to insert a NULL value to a
Date DataType field, that will be a great help on me.

Thanks!
 
Hi,


Missing # delimiters. Actually, you use 1 divided by 1 divided by 2001.
Try #1/1/2001#


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top