Subject Re: [IBO] interbase udflib vice mer udflib
Author Helen Borrie
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.


All for Open and Open for All
InterBase Developer Initiative ยท