What's wrong with my DateValue Query

[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!

 

[Michel Walsh]

Hi,


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


Hoping it may help,
Vanderghast, Access MVP