At 04:30 PM 18-02-01 +1300, you wrote:

>The reason why I had a look at mer's udflib is I need a 'diffdate' which
>I did not find so far elsewhere. I need the number of days between any
>two dates as in 'diffdate = abs(date1 - date2)';

You don't need a UDF for this - you can do it in DSQL with SQL arithmetic and the shipped abs() UDF:

select <fieldlist>, abs(date1 - date2) as diffdate from aTable

This returns a double which is in days.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________