> hi geoff,

> The two database is in dialect 3.

If that is the case then how did you get:

> THEDATE
>=========================
>
>2001-07-20 00:00:00.0000

??

The time portion of these examples really do make
it look like a timestamp rather than a date field.

Your original post showed the UDF declared as:
DECLARE EXTERNAL FUNCTION WEEKOFYEAR
DATE
RETURNS INTEGER BY VALUE
ENTRY_POINT 'WEEKOFYEAR'
MODULE_NAME 'dskudf.dll'

expecting a date - whereas THEDATE as showing in this
example is not a date it is a timestamp.

--
Geoff Worboys
Telesis Computing