
Null date values in Date/Time fields in Access DB
Sorry if this is a newbie question, but I have a Access DB with
date fields. The problem is that this date can be left blank when the
record is created. If I do this (leave it blank) I then get 'type
mismatch' when I do a search for this value using an SQL query.
I use this
if NOT Mydynaset("DateConfirmed") = ""
which gives 'Type Mismatch'
Should I be testing for IsNull?
Or should I make the field in the Database a Text field so that I can
have a blank (zero-length string) value? Surely there must be many databases
out there where a date field can be empty.
All help gratefully received.
--
Simon Rayner
Why not walk Offa's{*filter*} this year? 177 miles of uncrowded countryside.
The{*filter*} is more than 1200 years old. Email me for more details.