>i am vfp programmer using sql 2000. i have created cursoradapter in my dataenvironment using cursor in from. my user fill blank date
>after cursor updated store datetime in sql '01/01/1900 12:00:00 am'.
>user want to store blank datetime i have try to save null value. when user adding new record default null but user go on datetime text box mistakly type date. he want no need date here,he arase date and saveing record but datetime have been stored in sql
>'01/01/1900 12:00:00 am'.

You can use this function to generate a blank date:

        ' Return an empty date
        ' expT1 Date
        Public Function GetEmptyDate() As Date
            Return New Date(1899, 12, 30, 0, 0, 0)
        End Function