oledb provider for sql, date is not a recognized function name

[gagani]

I added a new command to the report. It's working fine when I write

solddate>={?FromDate} and solddate<={?ToDate} in the query.

But when I write,
solddate>=date(year({?FromDate}),1,1) and solddate<={?ToDate}

it's throwing an error: microsoft oledb provider for sql, date is not a
recognized function name.

Could anyone help with it.

 

[IanWaterman]

You can not use commands like that. A command must be SQL.

You can use your formula in the select expert

goto

Report-> Selection Formulas -> Record

Ian