Setting Null to date

[Oded Kovach]

Hello there

I have function that set date on date variable that return it by the
function

If no date should be set and i leave the date return value as it was on the
function the function returns 00:00:00 (leagel date on access and not on sql
server)

How can i return null value if no date should be returned?

 

[Douglas J. Steele]

What's the function?

In order to return a Null, the function must return a Variant, not a Date,
type.