[Beginner] Problem with Order by of a date

Hi all,
I'm building a query where I need to retrieve just 1 one row, which must be that with the highest Date (I mean that which is closest to the moment where the query is issued)

SELECT a.lista_campi_tpr, date_import
  FROM CELL_PR cp
   WHERE cp.id_cella = 'PZ81U1'
   AND ROWNUM < 2
   ORDER BY date_import DESC

The Date is date_import.......
unfortunately that doesn't work.......... anybody can help me ?
Thanks
Francesco Received on Tue Nov 08 2005 - 11:04:55 CST