All VFP data types are one character long. If you supply more than one character, only the first one is taken and the rest is ignored.

...
        del_dt T,;
...

You can use < pre > and < /pre > tags (w/o) spaces to preserve formatting of your code.

>I am using the following to create a new table:
>For date field i am doing datetime: but nothings happening it is still showing just date, after i run the following code:
>Can you please tell me how i can create a field with datetime(8):

>CREATE TABLE (mDataPath+'DOCUDEL.DBF') FREE (DOC_DEL_ID N(10, 0) NOT NULL,;
>	del_by      	C(40),;
>	del_dt      	Datetime( 8),;
>	proj_no     	C(15),;
>	workpkg_no  	C(15),;
>	file_name     	C(75),;
>	file_loc      	C(150))

>Thank you very much.