> Dear Expert,
>
> In the creation of a table, how do you initialize a date field
>
> For instance;
>
> The character fields have 'NULL' placed after them
>
>

<B> CREATE TABLE NEW_TABLE ( IDNO C(6) NULL, DATE_CURR D ___)</B>

>
>
> What do you place after a date field ?
>
>
> Thanks

The NULL didn't initialize the field, it just said that field allow NULLs to be stored in it.
If you want to have a default value you must use DEFAULT clause:

CREATE TABLE NEW_TABLE ( IDNO C ( 6 ) NULL DEFAULT 'Test', DATE_CURR D DEFAULT DATE())
APPEND BLANK
BROWSE NORMAL

-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.