Year() function in select statement

[Gary Edge]

I'm trying to select and group by the year of a date field in a sql 
statement.

I try: "select year(date_released), count(*) from atable group by 
year(date_released)"

and I get a nil cursor.

Even without the grouping I get a nil cursor. When using just "select 
date_released ..." it works. Anyone advice on the correct way to use 
the year() function in a select statement?
--

Best Regards,
Gary

--