You'll want to use NULL
>All Experts,
>
>i m trying to stroe empty datetime to sql server
>using
>
>dAppDat = Dtot(Ctod(' / / ')).
>
>But in sql server it stores like '01/01/1900:00:00'.
>So, how will i store empty date and time.
>
>Please help somebody who knows abt it....................
>
>regards
>Abdulla