You cannot return date from SQL Server, only datetime and it doesn't support empty dateime.

>I m trying to retrieve date and code from a sql database,
>and the condition is that if date filed is null retuns an empty date value,
>the satamentcode is similar to like this
>
>

>Select inv_Code, Isnull(inv_date, {})
>

>
>but it gives error
>
>and try this way also
>
>

>dDate  = Ctod('  /  /    ')
>Select inv_Code, Isnull(inv_date, dDate) And
>

>
>Again gives error
>
>

>Select inv_Code, Isnull(inv_date,' ')
>

>
>(This works fine but, Automatically storing very old random dates.
>i need empty dates for checking report in datewise conditions.)
>
>Anybody help me how to solve this probs.
>
>Thanks in Advance
>
>With Thanks and Regards
>Abdulla