I'm still having trouble with Oracle's terrible date implementation. I am attempting to select all the records from a certain month or year. My SQL statement is:<BR><BR><%<BR>oConn.execute("select * from MyTable where datepart(yyyy, DueDate)=2001")<BR>%><BR>I get the error "ORA-00904: invalid column name". It seems as if the database is interpreting the whole thing as the field name. In other words, my field name is "DueDate" but it thinks the field name is "datepart(yyyy, DueDate)". The reason I believe that to be true is because it works just fine if I use this SQL statement:<BR><%<BR>oConn.execute("select * from MyTable where DueDate=2001")<BR>%><BR>But that doesn't give me the recordset that I need. Can anyone see any mistake I am making or point me to a decent FAQ on dates in Oracle.<BR><BR>Thank you!