dates

I am trying to do a select on tables based on dates and I can't get it to work.

ex.

select * from table where initial_date < '01-Jan-99' and final_date > '01-Jan-99';

any idea why this doesn't work?

Thanks in advance,

Tim Received on Wed Jun 02 1999 - 14:16:33 CDT