Brian,

Unfortunately, a UDF can't detect NULL values. A change was made some
time ago (v5.0 I think) by Borland to remove this ability.

This is a feature which Firebird has on it's list of things to fix.
(And no, I don't know when this will be implemented)


Sean

> -----Original Message-----
> From: Brian Dunstan [mailto:bdunstan@...]
> Sent: Monday, June 25, 2001 9:53 AM
>
> Hi,
>
> how can I tell (within a UDF) if a null date is passed?
>
> I am developing UDF's in Delphi 5 for IB6.0 on WinTel.
>
> Thanks,
>
> Brian