Hi all,
How should I define a date field so that I can enter a blank (no value )
into my table.

I tried;
CREATE DOMAIN T_DATE AS DATE DEFAULT 'NOW' NOT NULL;
CREATE DOMAIN T_DATE2 AS DATE;
CREATE DOMAIN T_DATE AS DATE DEFAULT NULL;

ORDDATE T_DATE
ORDDATE T_DATE2
ORDDATE DATE

nothing seems to work, when I post from dbnavigator I get the error
"field ORDDATE must have a value"

what should I do?
Thanks
Daniel