I've run into problems with SQL doing some pre-processing stuff that throws off my UDFs. Could you put a DEBUGOUT right before the RETURN in "Date" to see what type of value it's returning? Possibly the first time through, it's getting something wierd.

Michelle


>I'm running into a problem with date functions not working when placed in a SQL statement:
>
>This works:
>
>? Date(Year(tbl.myDate), Month(tbl.myDate), 1)
>
>This returns "Function argument value, type or count is invalid":
>
>select Date(Year(tbl.myDate), Month(tbl.myDate), 1) as myDate from tbl
>
>What am I missing here?