>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?

It fails if you have empty dates. Try adding a WHERE !EMPTY(tbl.myDate) to your SELECT.