Not in SQL Server, NULL is as close as you can get with either datetime or smalldatetime. SQL Server doesn't have anything like VFP's {/:} (empty datetime).
>Hi,
>
>Thanks for your reply,
>But the value store in the field 'NULL' only.
>is there any way to store like ' / / ' format.
>
>Regards
>Abdulla