>>>>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
>
>The table, if not a VFP table, then should be set to support null for a datetime field. Otherwise there is nothing specifying a blank/empty datetime in other backends (the common ones I know of) - because of how internally it's stored as a numeric where 0 points to a valid datetime.
>Cetin
But it IS a VFP table.
I suppose I could enable nulls but I'd rather not if there is a way.
- Don