Error:SQL Problems: ERROR :operator does not exists:date>= character varying

i am using iReport 3.6.0 with postgresql datab开发者_运维问答ase ,for date type parameter its giving the following error when writing query "Error:SQL Problems: ERROR :operator does not exists:date>= character varying" please help

There should be datefield >= textfield::date. I think that there would be comparing two date fields not two textfields so the datefield::text >= textfield would be rather wrong.

See PostgreSQL 8.3 Release Notes for explanation and workaround. You should use

datefield::text>=textfield

The cast function help too:

cast(date_trunc('year', current_date) as text)