function in where clause+ axapta2009

Question

I am having Illegal use of WHERE expression for the following statement

select dateField from tableName
where dayname(dayofwk(tableName.dateField)) like 'sunday';

Pls help

Answer 1

You cannot use a function in a where clause, or in any select statement