>>Given:
>>

>>< %
>>function formatdate2(lddate)
>>if isdate(lddate) then
>>   formatdate2 = lddate
>>else
>>	formatedate2 = ??? what goes here ???
>>end if	
>>end function
>>
>>
>>   .fields("a_scoping").value = formatdate2(request.form("a_scoping"))
>>% >
>>

>>How would you finish the function to insert a blank date into a_scoping?
>>
>>Thanks
>
>I think in VB null is called Nothing
>
>Cetin

Ah yes, but I don't want a null, I want a blank or empty. The table does not support nulls. I tried both blank and empty but can't seem to get the syntax right.
- Don